# Auto\_increment\_increment help

**URL:** <https://forums.percona.com/t/auto-increment-increment-help/13458>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [December 13, 2021, 3:10pm UTC](https://forums.percona.com/t/auto-increment-increment-help/13458 "2021-12-13T15:10:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mikem](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mikem](https://forums.percona.com/u/Mikem)\
**Post date:** [December 13, 2021, 3:10pm UTC](https://forums.percona.com/t/auto-increment-increment-help/13458/1 "2021-12-13T15:10:50Z")

</div>

I noticed the default value for auto\_increent\_increment is 3 in my cluster where it is normally 1 using basic Mysql. Is this a function of the Percona Cluster software? My cluster size is 3. I have tried to change it to 1 in the my.cnf file but it has no effect (after restart). I can change it using Mysql\>’ set global…’ but it does not persist obviously. I understand why this is useful in a Master-Slave situation but feel like it is not necessary with the cluster setup.

---

<div class="post-metadata">

**Author:** ![Mikem](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mikem](https://forums.percona.com/u/Mikem)\
**Post date:** [December 15, 2021, 1:09pm UTC](https://forums.percona.com/t/auto-increment-increment-help/13458/2 "2021-12-15T13:09:48Z")

</div>

I found the answer. wsrep auto\_increment\_control.

Thanks!

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [December 15, 2021, 1:25pm UTC](https://forums.percona.com/t/auto-increment-increment-help/13458/3 "2021-12-15T13:25:44Z")

</div>

Hello Mikem, indeed the auto increment are normally controlled via the option you mention. Having different values per-node can be useful to debug where a transaction came from.