# Identify MySQL query for read & write

**URL:** <https://forums.percona.com/t/identify-mysql-query-for-read-write/14431>\
**Category:** Percona Server for MySQL 5.7\
**Tags:** mysql, percona\
**Created:** [February 16, 2022, 11:27am UTC](https://forums.percona.com/t/identify-mysql-query-for-read-write/14431 "2022-02-16T11:27:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![venkatesh](https://avatars.discourse-cdn.com/v4/letter/v/77aa72/32.png) [@venkatesh](https://forums.percona.com/u/venkatesh)\
**Post date:** [February 16, 2022, 11:27am UTC](https://forums.percona.com/t/identify-mysql-query-for-read-write/14431/1 "2022-02-16T11:27:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [February 16, 2022, 3:46pm UTC](https://forums.percona.com/t/identify-mysql-query-for-read-write/14431/2 "2022-02-16T15:46:55Z")

</div>

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](https://www.percona.com/blog/2019/02/20/proxysql-native-support-for-percona-xtradb-cluster-pxc/) for more info