Load Balancing

MariaDB Enterprise optimizes responsiveness to workloads by leveraging MariaDB MaxScale for transparent load balancing.

Load Balancing Solutions

MariaDB Enterprise X6 supports load balancing with several different multi-node solutions.

MariaDB Replication

MariaDB Replication supports load balancing reads.

Replica servers replicate data from a primary server asynchronously or semi-synchronously using binary logs.

Galera Cluster

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

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.

MariaDB Xpand supports multiple topologies. Several options are described below. MariaDB products can be deployed in many different topologies. The topologies on this page are representative. MariaDB products can be deployed to form other topologies, leverage advanced product capabilities, or combine the capabilities of multiple topologies.

Xpand Performance Topology

MariaDB Xpand Performance topology delivers maximum throughput and lowest latency.

Xpand Storage Engine Topology

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:

Connection-Based Load Balancing

Read Connection Router (readconnroute) provides connection-based load balancing:

Multi-node Solution

Description

MariaDB Replication

When used with MaxScale's MariaDB Monitor (mariadbmon), Read Connection Router (readconnroute) can be configured to route connections to the primary server, a replica server, or any running server.

Galera Cluster

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.

MariaDB Enterprise ColumnStore

When used with MaxScale's MariaDB Monitor (mariadbmon), Read Connection Router (readconnroute) can be configured to route connections to the primary server, a replica server, or any running server.

MariaDB Xpand Performance Topology

When used with MaxScale's Xpand Monitor (xpandmon), Read Connection Router (readconnroute) can be configured to route connections to any running server.

MariaDB Xpand Storage Engine Topology

When used with MaxScale's MariaDB Monitor (mariadbmon), Read Connection Router (readconnroute) can be configured to route connections to the primary server, a replica server, or any running 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:

Topology

Description

Xpand Performance

  • Delivers maximum throughput and lowest latency.

  • Uses MaxScale as a transparent database proxy to monitor node health and route queries to Xpand nodes.

  • Xpand stores data in a distributed manner and executes queries using parallel query evaluation.

Xpand Storage Engine

  • Leverages Xpand's benefits and maximizes compatibility with MariaDB Enterprise Server (ES).

  • Uses MaxScale as a transparent database proxy to monitor node health and route queries to ES nodes.

  • ES nodes store non-Xpand tables and interact with Xpand tables using the Xpand Storage Engine.

  • Xpand stores data for Xpand tables in a distributed manner and executes queries using parallel query evaluation.

For additional information, see "MariaDB Xpand Topologies" and "Deploy Xpand 5.3".