DISQUS

DISQUS Hello! Homo-Adminus Blog is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Jump to original thread »
Author

MySQL Master-Master replication manager released

Started by Scoundrel · 9 months ago

So, I’s been a long time since I wrote my last post here. Lots of work and almost no new interesting technologies in my work caused such delay. But today I’m proud to announce release of really interesting project: MySQL Master-Master replication manager - set of flexible ... Continue reading »

3 comments

  • 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 ?
  • 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).
  • 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.

Add New Comment

Returning? Login