I had gone through the basic MySQL replication tutorial earlier for a good mysql failover solution and it works like a charm. However, for high-availability solutions we need a round-robin-type of replication. This tutorial shows a very good example on how to setup a master-to-master replication for HA scenarios. Do make sure that you take care of your AUTO_INCREMENT variables!

Trackback URI | Comments RSS