Johan, Are you sure mmm couldn't handle this?
Machiel, 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? Regards John On 24 November 2010 13:08, Johan De Meersman <vegiv...@tuxera.be> wrote: > You can't, plain and simple - a slave may only have a single master. > > You could script binlog shipping, I suppose, if you're so inclined, and > apply them on the slave. No guarantees about it working as expected, > though. > > > On Wed, Nov 24, 2010 at 1:20 PM, Machiel Richards <machi...@rdc.co.za > >wrote: > > > Hi All > > > > I am back once again with another replication question (maybe this > > can also be handled by MMM but not sure) this time for a different > > client. > > > > We are trying to find out how to setup 3 different masters to > > replicate to a single slave server (without the need to have 3 different > > instances running on the slave machine). > > > > Does anybody have any ideas? > > > > Any ideas will be greatly appreciated. > > > > Regards > > Machiel > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk
