Understanding MaxScale's Read Connection Router

MaxScale's Read Connection Router (readconnroute) performs connection-based load balancing. For each client connected to MaxScale, it opens up a connection to a single back-end database server. When the client sends a query to MaxScale, it routes the query to the connection opened up with the back-end database server. It can be configured to load balance connections between primary servers, replica servers, or any server.

What Does the Read Connection Router Support?

The Read Connection Router (readconnroute) supports:

When to Use the Read Connection Router?

The Read Connection Router (readconnroute) allows you to:

  • Perform connection-based load balancing.

  • For MariaDB Replication deployments, it can be configured to route connections to the primary server, a replica server, or any running server.

  • For Galera Cluster deployments, it can be configured to route connections to the primary server, a replica server, any synced server, or any running server.

  • For ColumnStore deployments, it can be configured to route connections to the primary server, a replica server, or any running server.