> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/designing-for-maxscales-readwrite-split-router.md).

# Designing for MaxScale's Read/Write Split Router

[MaxScale's Read/Write Split Router (readwritesplit)](/docs/maxscale/reference/maxscale-routers/maxscale-readwritesplit.md) 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?](/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/routing-statements-with-maxscales-readwrite-split-router.md)
* How does the [Read/Write Split Router select replica servers to load balance queries?](/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/selecting-replica-servers-with-maxscales-readwrite-split-router.md)
* How does the [Write Split Router reconnect client connections to the new primary server after automatic failover?](/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/reconnecting-to-the-primary-server-with-maxscales-readwrite-split-router.md)
* How does the [Read/Write Split Router retry failed reads?](/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/retrying-failed-reads-with-maxscales-readwrite-split-router.md)
* How does the [Read/Write Split Router retry failed queries during automatic failover?](/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/delayed-retrying-of-failed-queries-with-maxscales-readwrite-split-router.md)

Additional information is available [here](/docs/maxscale/reference/maxscale-routers/maxscale-readwritesplit.md)

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

{% @marketo/form formId="4316" %}