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 Xpand deployments, it can be configured to route connections to any running server.
Deploying Read Connection Router