MariaDB Platform optimizes responsiveness to workloads by leveraging MariaDB MaxScale for transparent load balancing.
Load Balancing Solutions
MariaDB Platform X5 supports load balancing with several different multi-node solutions.
MariaDB Replication supports load balancing reads.
Replica servers replicate data from a primary server asynchronously or semi-synchronously using binary logs.
Galera Cluster supports load balancing reads.
Cluster nodes replicate data using certification-based replication implemented by the Galera 3 or Galera 4 plugin, depending on the version of MariaDB.
MariaDB Enterprise ColumnStore
MariaDB Enterprise ColumnStore supports load balancing reads in multi-node deployments.
MariaDB Xpand supports load balancing reads and writes.
Xpand divides tables and indexes into slices, and it distributes those slices among all the nodes. Any node can handle any request. Transactions are automatically coordinated across nodes, and writes are automatically sent to the node where the data resides.
It is available in two topologies:
MariaDB Xpand Performance topology delivers maximum throughput and lowest latency.
Xpand Storage Engine topology leverages Xpand's benefits and maximize compatibility with MariaDB Enterprise Server (ES). It allows Xpand users to leverage ES features like window functions, CTEs, and cross-engine JOINs.
For additional information, see "MariaDB Xpand Topologies".
Load Balancing with MaxScale
MariaDB MaxScale provides multiple load balancing options.
Query-Based Load Balancing
Read/Write Split Router (readwritesplit) provides query-based load balancing with advanced features:
Query-based routing, so that replica servers can be properly utilized.
Automatic primary server re-connection in case of server failure.
Automatic transaction replay in case of server failure or deadlock.
Maintenance of connection state on behalf of applications.
Causal reads to ensure consistent read-your-writes behavior.
Adaptive query-based load balancing to optimize the routing of traffic to the fastest database instance based on actual server load conditions.
Retries of failed reads to ensure that the client is not affected by server failures.
Delayed retries of failed queries to ensure that the client is not affected by temporary cluster failures.
Connection-Based Load Balancing
Read Connection Router (readconnroute) provides connection-based load balancing:
When used with MaxScale's Galera Monitor (galeramon), Read Connection Router (readconnroute) can be configured to route connections to the primary server, a replica server, any synced server, or any running server.
When used with MaxScale's Xpand Monitor (
Deploy MariaDB Enterprise Server with Load Balancing
Choose a multi-node solution to deploy for MariaDB Enterprise Server:
Deploy MariaDB Xpand
MariaDB Xpand provides distributed SQL, high availability, fault tolerance, write scaling, and horizontal scale-out for transactional workloads. It is available in a standalone topology and in a topology with MariaDB Enterprise Server using the Xpand storage engine. Both topologies support high availability.
To deploy MariaDB Xpand, choose a topology:
Deploy MariaDB Community Server with Load Balancing
Choose a multi-node solution to deploy for MariaDB Community Server: