PXC / ProxySQL - Single Writer / wsrep_auto_increment_control = OFF ?!

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

I have recently transitioned a database to PXC 8.0 and configured ProxySQL with read/write split and with a single writer to avoid deadlocks. (2 readers / 1 writer)

So far everything works perfectly after tweaking a few parameters.

My question is: As i’m only ever using a single writer is it safe to set “wsrep_auto_increment_control” to “OFF” and get gapless auto-increment IDs?

Anything I need to keep in mind?

2 Likes
2

Hello @joshfifty, you should be fine in turning off wsrep_auto_increment_control for situations like this.

3 Likes
3

thank you for confirming my assumption.

2 Likes