# Read/write split vs. weight in Proxysql

**URL:** https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571
**Category:** ProxySQL
**Created:** [April 6, 2024, 7:29am UTC](https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571 "2024-04-06T07:29:04Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Lars\_Erik\_Dangvard\_J](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lars_erik_dangvard_j/32/14572_2.png) [@Lars\_Erik\_Dangvard\_J](https://forums.percona.com/u/Lars_Erik_Dangvard_J)
#### Post date: [April 6, 2024, 7:29am UTC](https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571/1 "2024-04-06T07:29:04Z")

</div>

Is setting the same weight for readers the same as making rules for reads to go to nodes configured as readers in Proxysql?

Right now I have one PXC node that gets all writes and reads because of higher weight as both writer and reader. Will the same weight on all reader nodes make Proxysql load balance between reader nodes?

---

<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: [April 7, 2024, 2:54am UTC](https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571/2 "2024-04-07T02:54:35Z")

</div>

@Lars_Erik_Dangvard_J,  
You probably have one node getting everything because you’ve configured it as the default hostgroup. If you want to split reads/writes, you will need to create 2 rules: 1) ^SELECT.\*FOR UPDATE and 2) ^SELECT both of those rules should have a hostgroup destination for your reader pool. Within your reader pool, you should only have readers with equal weights.  
You should be using the mysql\_galera\_hostgroups table too in ProxySQL, which will manage writer/reader pool membership based on galera status of each node.