A customer asked whether we they could have 10 or more masters
consolidate all the data into a single central slave. After
getting a bit more information from them and seeing the
application functionality, it was clear that MySQL Labs 5.7.5
Multi Source Replication could be a good candidate. Why?:
– Each master is independent from the rest of the masters.
– One-way traffic: there is only one way to update a row, and
that’s from the master.
– All the masters use the same schema and table, but no single
master will ever need to, nor be able to update a row from
another master.
– PK determined via app & master env.
Multisource replication is still in http://labs.mysql.com, but here’s what I did to test it out.
First, I read:
…