I wanted to do some tests with MariaDB MaxScale and realized that
the two existing routers (beyond the binlog router that is, which
is a bit special) didn't do what I wanted them to do. What I was
looking for was a simple round-robin feature and none of
readconnroute nor readwritesplit could be configured to do this,
they are just too smart for my simple experiment.
Why would you want a round-robin router then? Well, one use case is when you are INSERTing a lot of data and you just want to persist it. You don't have the use case where you have to SELECT data from all servers, but in the case you need it, you just select from all …