MySQL Master-Master replication manager released
Posted by Oleksiy Kovyrin under Databases, Development, Networks · 
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 scripts for management different MySQL deployment schemes with master-master replication involved.
More information about this software could be found in detailed announce in Peter Zaitsev blog (actually this software was created by me for his company’s client) or at project page. All your questions and suggestions welcomed in MMM development group on Google Groups. If you’d like to support this software on Digg.com, you’re welcome. 
Related posts:
3 Responses to this entry
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.