Re: Multi master - multi slave partial replication

[Jeremy Smyth]

As long as M1 and M2 don't have overlapping table names, you can achieve this as follows:

- M1 as master
- M2 as a relay slave - slave of M1 and master to all the named slaves

Create tables in M2 mirroring the schema of those of M1 that you want to replicate, but using the BLACKHOLE storage engine (you don't want to store M1's data in M2 after all).

Then, in the various S* machines, all slaves of M2, use appropriate combinations of --replicate-do-table or --replicate-do-db or other filters as described in http://dev.mysql.com/doc/refman/5.6/en/replication-rules.html to pick and choose what bits of M2's output each one replicates.