How To Avoid Auto-Increment Collisions During Multi-Master Replication

Author: , September 25th, 2013

If you are inserting to the same table at the same time at two or more different sites, and using bi-directional or multi-master replication, then the auto-increment keys need to be offset so they do not conflict or the application needs to be be able to generate it’s own unique keys. Use the auto-increment-increment and […]