On Wed, Nov 24, 2010 at 2:50 PM, John Daisley <daisleyj...@googlemail.com>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
