> > Master/Master in MySQL requires Galera and at least 3 servers. Why do you > need Master/Master write? It's Write one, read many, with automatic > failover, especially if you implement with Pacemaker. > > ~Noah
Hi Noah I'm not sure where you have your information from, but it's wrong. I do not even know what Galera is, nor do I have 3 servers. MySQL master-master replication have worked fine out of the box at least since 5.x The reason why you need more than 1 master is to be able to still write to the DB when the primary master goes down, as it would in a normal standalone setup or master-slave setup. Not to mention its better performance to write on many, and on top of that introducing anything with a failover is a risk in itself, since you never know if it works when you need it. With true master-master replication you know everything works, because you use both masters everyday, unlike a passive/cold/slave server. Hope that explains it :) Med venlig hilsen / Best regards Jonas Akrouh Larsen TechBiz ApS Laplandsgade 4, 2. sal 2300 København S Office: 7020 0979 Direct: 3336 9974 Mobile: 5120 1096 Web: www.techbiz.dk _______________________________________________ http://pledgie.com/campaigns/12056
