On Wed, Nov 24, 2010 at 2:50 PM, John Daisley <daisleyjohn@stripped>wrote:
> Are you sure mmm couldn't handle this?
That, I don't know, but MySQL's internal replication mechanisms definitely
don't support multimaster slaves. If mmm does it, it'll likely be akin to
the offline log shipping I proposed earlier.
> Maybe you could `simulate` the whole thing using some federated tables on
> one of the slave instances? Then although you are replicating to 3
> you could access all the data from a single instance?
Purely with federated tables, you're not actually replicating. You'd have
the data visible on the "slave", but it would be useless for
failover/backup; and it would be less than optimal for querying since you'll
be pulling all the data off the primaries on every select anyway.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel