All pages
Powered by GitBook
1 of 1

Loading...

Designing for MaxScale's Read/Write Split Router

Optimize applications for read-write splitting. This guide outlines best practices for transaction management and connection handling to ensure compatibility with MaxScale.

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.

This page contains topics that need to be considered when designing applications that use the Read/Write Split Router.

  • How does the Read/Write Split Router route queries?

  • How does the Read/Write Split Router select replica servers to load balance queries?

  • How does the

  • How does the

  • How does the

Additional information is available

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

Write Split Router reconnect client connections to the new primary server after automatic failover?
Read/Write Split Router retry failed reads?
Read/Write Split Router retry failed queries during automatic failover?
here