ProxySQL Setting rules to filter to some certain selects


Is it possible to have ProxySQL filter some certain select to the replica. I mean it should direct the SELECT (certain/particular/specific ) To the slave. I want proxySQL to direct the traffic for this certain queries to the SLAVE.

Yes this is possible. See here for some examples: Achieving Consistent Read and High Availability with Percona XtraDB Cluster 8.0 - Percona Database Performance Blog

1 Like