Conflict Avoidance with auto_increment_increment and auto_increment_offset

General Questions
1

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?

1 Like
2

I suggest to stay away from master-master. Check out: Resolving the MySQL Active-Active Replication Dilemma - Percona Database Performance Blog
Also setting idempotent mode could cause data drift issues so you should stick to strict mode if you care about your data.

2 Likes