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
> instances
> 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
