DISQUS

DISQUS Hello!  The comments on this profile are unclaimed and thus are unverified.

Do they belong to you? Claim these comments.

PSI's picture

Unregistered

Feeds

aliases

  • PSI

PSI

2 years ago

in MySQL Master-Master replication manager released on Homo-Adminus Blog
For MySQL 5.0.2 or above

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.
Returning? Login