Understanding MaxScale's Read/Write Split Router

MaxScale's Read/Write Split Router (readwritesplit) performs query-based load balancing. For each client connected to MaxScale, it opens up connections to multiple back-end database servers. When the client sends a write query to MaxScale, it routes the query to the connection opened with the primary server. When the client sends a read query to MaxScale, it routes the query to a connection opened with one of the replicas.

What Does the Read/Write Split Router Support?

The Read/Write Split Router (readwritesplit) supports:

• deployments.

• deployments.

• and deployments.

When to Use the Read/Write Split Router?

The allows you to:

• Perform query-based load balancing.

• Route client connections to multiple servers simultaneously.

• Route write queries to primary and read queries to replicas.

• Automatically reconnect clients to the new primary after failover or switchover.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}