On 02/23/2011 05:29 PM, [email protected] wrote: > Both mysql 5.1.37 databases are replicated on master-master mysql > replication. about half of the user read their mail on the first > server and the second half on the other server. The problems happens > on both.
Aaii. Yes, I know some people have reported using this setup without problems, but really: this is the number one no-go. /// Do not use multi-master setups while writing on more than one node! /// Master-master replication is great, as long as you only do writes on *one* of the participating nodes. The problem you suffer from is perfectly explained by collisions and race-conditions. try reading this thread for starters: http://www.mail-archive.com/[email protected]/msg14937.html In your specific case: make sure the daemons on both locations connect to the same mysql instance. I've used mysql-mmm with great success for managing the highly available IP addresses, if both cluster-nodes are in the same segment. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
