Hello,
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