-
Website
http://blog.kovyrin.net -
Original page
http://blog.kovyrin.net/2007/04/05/mysql-master-master-replication-manager-released/ -
Subscribe
All Comments -
Community
-
Top Commenters
-
for you health
3 comments · 1 points
-
jamiew
1 comment · 6 points
-
qu1j0t3
1 comment · 1 points
-
TomK32
1 comment · 1 points
-
Scoundrel
9 comments · 1 points
-
-
Popular Threads
In the my.cnf file on server1 add:
auto_increment_increment=2
auto_increment_offset=1
In the my.cnf file on server2 add:
auto_increment_increment=2
auto_increment_offset=2
This will make the auto-increment on server1 go, 1,3,5,7,9,etc... and on server2 go, 2,4,6,8,etc... thereby preventing collisions.