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 <vegivamp@stripped> 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 <machielr@stripped
> >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.daisley@stripped
