The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication.
Now let’s focus on the routing module performing read-write splits.
This is our current configuration:
[Splitter Service] type=service router=readwritesplit servers=percona1, percona2 max_slave_replication_lag=30 user=maxscale passwd=264D375EC77998F13F4D0EC739AABAD4
This …[Read more]