# XtraDB Cluster & ProxySQL Read-Write-Split

**URL:** <https://forums.percona.com/t/xtradb-cluster-proxysql-read-write-split/20592>\
**Category:** Uncategorized\
**Tags:** community, mysql, percona\
**Created:** [March 16, 2023, 8:51am UTC](https://forums.percona.com/t/xtradb-cluster-proxysql-read-write-split/20592 "2023-03-16T08:51:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![A.Wormuth](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@A.Wormuth](https://forums.percona.com/u/A.Wormuth)\
**Post date:** [March 16, 2023, 8:51am UTC](https://forums.percona.com/t/xtradb-cluster-proxysql-read-write-split/20592/1 "2023-03-16T08:51:21Z")

</div>

Hi,

I’ve setup a 3 Node XtraDB Cluster with ProxySQL.

**What I would like to setup with this now:**  
Only one of the 3 servers should be the write node, the other 2 should only be read nodes.  
I’ve read about the read-write-split to configure but this seems to be like static linking one special node as write node…  
Is there a way to configure one server as write and the other two as read nodes, but if the write server will go down another previous read-only-server will take over the write role?

Happy for any hints 🙂

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [March 16, 2023, 2:06pm UTC](https://forums.percona.com/t/xtradb-cluster-proxysql-read-write-split/20592/2 "2023-03-16T14:06:18Z")

</div>

Hello @A.Wormuth,  
Check out the ProxySQL documentation on configuring Galera/PXC

> **[Galera Configuration - ProxySQL](https://proxysql.com/documentation/galera-configuration/)**
>
> ProxySQL support for Galera ProxySQL provides the following parameters and configuration tables specifically for Galera: Health \[…\]

ProxySQL will auto-manage which node goes into the writer HG so that you only have 1 writer at a time. If that node goes offline, proxysql will move one of the readers.
