DEV Community

Muhammad Abdullah
Muhammad Abdullah

Posted on

Internals of MariaDB - Architecture

MariaDB is an open-source, community-driven fork of the MySQL relational database management system (RDBMS). MariaDB is a widely used database management system that is known for its high performance, scalability, and reliability. It is developed and maintained by the MariaDB Foundation, a non-profit organization that is committed to promoting the development and adoption of open-source database technology. In this article, we will explore the internals of MariaDB and understand how it works.

Architecture

MariaDB follows a client-server architecture where the database server process listens for incoming connections from client applications. The server process manages all the database operations, such as creating and managing databases, executing queries, and maintaining data consistency.

The MariaDB server architecture is composed of several key components:

  • Connection Manager: It manages incoming client connections, maintains session state, and routes requests to the appropriate thread.
  • Query Cache: It stores the results of frequently executed queries in memory, which improves performance by reducing the number of disk accesses.
  • Storage Engine: It is responsible for managing the physical storage of data on disk, and for providing an interface for reading and writing data.
  • Query Optimizer: It is responsible for analyzing SQL queries and generating an optimized execution plan that minimizes disk and CPU usage.
  • InnoDB: It is the default storage engine for MariaDB, which provides support for transactions, foreign keys, and row-level locking.
  • MyISAM: It is another storage engine that is used for read-heavy workloads, as it supports full-text search and faster reads.
  • Performance Schema: It provides a way to monitor database performance and identify performance bottlenecks.

Top comments (0)