Retrying Failed Reads with MaxScale's Read/Write Split Router
Overview
The Read/Write Split Router (readwritesplit) routes write queries to the primary server and load balances read-only queries between one or more replica servers. If a read-only query fails, then the router can retry the query on a different server.
Configuring Retries for Failed Reads
1. Configure retries for failed reads by configuring the retry_failed_reads parameter for the Read/Write Split Router in maxscale.cnf.
For example:
[split-router] type = service router = readwritesplit ... retry_failed_reads = true
2. Restart the MaxScale instance.
$ sudo systemctl restart maxscale
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
