Identify MySQL query for read & write


I have a scenario where 3 MySQL database server nodes are maintained and currently the writes are performed to all the 3 nodes.
Ideally, I’m assuming to handle the write to a single node and read to the other 2 nodes? Can Percona help to achieve this?

Appreciate your help & Thanks in Advance

Hi Venk, assuming this is Percona XtraDB Cluster, normally people can install ProxySQL on the app servers (or in dedicated servers) to handle read/write splitting. You can check out ProxySQL Native Support for Percona XtraDB Cluster (PXC) - Percona Database Performance Blog for more info

1 Like