I have 3 Mysql servers that I would like to replicate: two (including the main server) are local and one is remote. Let's call my main server A, the secondary server B, and a remote, development server C.
As a possible configuration, I started reading about a ring configuration. Some comments seem to look down on this type of topology.
My question is, given the current state of Mysql 5.1, what types of master-master topologies are advisable and known to be fault-tolerant?
Is a ring really a bad idea, in general?
In my case, A and B are on an intranet that isn't expected to have any network failures so B can theoretically be used as a failover for A. Most of the time, I am working on C, a remote machine, which sometimes gets network hiccups in reaching A and B. None of the data is currently critical (ie as long as they eventually get mirrored, it's fine), but I expect A and B to be mirrored tightly - within say a 5 second timeframe on light loads (I think this should be an easy requirement given my preliminary tests).
I currently have B as a Slave to A, but I am looking forward to going Master-Master on A, B, and C.