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?