Friday, April 20, 2007

More options: MySQL Multi Master Manager

I am very interested in this project, but I am not fond of the name. The project provides tools do automate failover from the failed master to the new master. This is extremely useful. But the name makes me think it is a utility for managing a multi-master MySQL deployment. I don't have much use for that -- how do you maintain database consistency when updates occur on multiple masters?
Posted by Mark Callaghan at 12:20 PM
Labels:

1 comment:

  1. By setting server variables such that auto-incremented fields are spaced and off-set depending on the server involved. http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html explains in better detail.

    ReplyDelete

Subscribe to: Post Comments (Atom)
 
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.