Retrying Failed Reads with MaxScale's Read/Write Split Router
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
Configure retries for failed reads by configuring the
retry_failed_readsparameter for the Read/Write Split Router in
[split-router] type = service router = readwritesplit ... retry_failed_reads = true
Restart the MaxScale instance.
$ sudo systemctl restart maxscale