On Thu, Nov 04, 2010 at 08:23:04AM -1000, Paul Graydon spake thusly: > I've used mysql-mmm in the past as well, in production environments with > 2 masters and 4 slaves, where master database servers have gone down.
Another very useful tool in this area is maatkit. Maatkit is genious. Among many other things it provides a fast on-line way to make sure your databases are in sync and recover from accidentally getting out of sync. If you are running a master/master/slave setup you need it. Just make sure you use the latest version as the very old version currently shipping with RHEL/CentOS has at least one very bad bug in mk-table-sync. But newer stuff has been very solid for us. -- Tracy Reed http://tracyreed.org
pgpd5SjESujAr.pgp
Description: PGP signature
_______________________________________________ Tech mailing list Tech@lists.lopsa.org http://lists.lopsa.org/cgi-bin/mailman/listinfo/tech This list provided by the League of Professional System Administrators http://lopsa.org/
