tag:blogger.com,1999:blog-375697951860081841.post4776379620542221402..comments2009-09-04T12:46:36.130+01:00Jonathanhttp://www.blogger.com/profile/17336586681878234499BoogyBo@gmail.comBlogger1125tag:blogger.com,1999:blog-375697951860081841.post-88366194811013567062009-03-04T15:31:43.258Z2009-03-04T15:31:43.258ZThree quick comments regarding "Master/Master" replication.<BR/><BR/>. You should never assuming your MySQL slave is consistent with your Master. You need to do adequate checking first.<BR/>. You must be very careful that your slave environment is up to date, especially during your failover.<BR/>. It's a general misconception that active master/master for load balancing spreads the load, therefore improves performance. All writes occur twice, regardless, so your improvements in a low volume system is only latency. In a high volume system, the single threaded nature of replication can actually hurt performance.<BR/><BR/><BR/>Ronald<BR/>http://42sql.comRonald Bradfordhttp://www.blogger.com/profile/16170615042077930093noreply@blogger.com