Identify MySQL query for read & write

MySQL & MariaDB Percona Server for MySQL 5.7
,
1

Hi,

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
Venk

2

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