DISQUS

Homo-Adminus Blog: MySQL Master-Master replication manager released

  • Mihai Secasiu · 2 years ago
    is the web server able to write to any of the masters at any time ? what happens with databases that use auto increment fields ? how do you manage conflicts ?
  • Scoundrel · 2 years ago
    2Patchlog: This software works with classic master-master schemes where one of the master is active (handles writes and, sometimes, reads) and other is passive (receives updates via replication and could handle reads).
  • PSI · 2 years ago
    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.