# Conflict Avoidance with auto\_increment\_increment and auto\_increment\_offset

**URL:** <https://forums.percona.com/t/conflict-avoidance-with-auto-increment-increment-and-auto-increment-offset/11965>\
**Category:** General Questions\
**Tags:** mysql\
**Created:** [August 29, 2021, 10:50am UTC](https://forums.percona.com/t/conflict-avoidance-with-auto-increment-increment-and-auto-increment-offset/11965 "2021-08-29T10:50:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charan/32/4357_2.png) [@Charan](https://forums.percona.com/u/Charan)\
**Post date:** [August 29, 2021, 10:50am UTC](https://forums.percona.com/t/conflict-avoidance-with-auto-increment-increment-and-auto-increment-offset/11965/1 "2021-08-29T10:50:39Z")

</div>

Many blogs are saying we need to set that variables in Master-Master replication. and Percona blog seen set slave\_exec\_mode=IDEMPOTENT. If we set it will ignore the Duplicate key error.

if we set slave\_skip\_errors=error\_code. This also help us to ignore that error.

I Wanted to know which one is best practice and which is more efficient. Can some one please help me with the clear idea?

---

<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:** [August 30, 2021, 12:58pm UTC](https://forums.percona.com/t/conflict-avoidance-with-auto-increment-increment-and-auto-increment-offset/11965/2 "2021-08-30T12:58:55Z")

</div>

I suggest to stay away from master-master. Check out: [Resolving the MySQL Active-Active Replication Dilemma - Percona Database Performance Blog](https://www.percona.com/blog/2021/04/28/resolving-the-mysql-active-active-replication-dilemma/)  
Also setting idempotent mode could cause data drift issues so you should stick to strict mode if you care about your data.