How to Test ProxySQL Read/Write Split with sysbench
Getting Accurate Results with Percona XtraDB Cluster
You’ve configured ProxySQL with read/write splitting. You fire up sysbench to verify it works and… all queries go to the writer hostgroup. The rules are correct, sysbench is running, but the split isn’t happening.