# PXC / ProxySQL - Single Writer / wsrep\_auto\_increment\_control = OFF ?!

**URL:** <https://forums.percona.com/t/pxc-proxysql-single-writer-wsrep-auto-increment-control-off/9184>\
**Category:** Percona XtraDB Cluster 8.x\
**Tags:** percona\
**Created:** [February 9, 2021, 12:35pm UTC](https://forums.percona.com/t/pxc-proxysql-single-writer-wsrep-auto-increment-control-off/9184 "2021-02-09T12:35:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshfifty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshfifty/32/224_2.png) [@joshfifty](https://forums.percona.com/u/joshfifty)\
**Post date:** [February 9, 2021, 12:35pm UTC](https://forums.percona.com/t/pxc-proxysql-single-writer-wsrep-auto-increment-control-off/9184/1 "2021-02-09T12:35:25Z")

</div>

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?

> **[Percona Software Documentation](https://docs.percona.com/percona-xtradb-cluster/8.0/wsrep-system-index.html)**
>
> .container-box-download { justify-content: flex-start; } .container-button-learn-more { margin-bottom: 10px; } .logo-server-home { background: url(/img/product-logos/sprite.png)

Anything I need to keep in mind?

---

<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:** [February 9, 2021, 2:39pm UTC](https://forums.percona.com/t/pxc-proxysql-single-writer-wsrep-auto-increment-control-off/9184/2 "2021-02-09T14:39:13Z")

</div>

Hello @joshfifty, you should be fine in turning off wsrep\_auto\_increment\_control for situations like this.

---

<div class="post-metadata">

**Author:** ![joshfifty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshfifty/32/224_2.png) [@joshfifty](https://forums.percona.com/u/joshfifty)\
**Post date:** [February 9, 2021, 11:59pm UTC](https://forums.percona.com/t/pxc-proxysql-single-writer-wsrep-auto-increment-control-off/9184/3 "2021-02-09T23:59:34Z")

</div>

thank you for confirming my assumption.