Why Multi source replication is required?
MySQL has limitation of not allowing to replicate multiple DB’s
from different master host on a single slave. MySQL
replication had a limitation, fixed with this new release, that
said that one slave could have only one master. That is a
limiting factor when we are designing our replication
environment. There were some “hacks” to make it work, but now
there is an official way.
What is multisource replication?
MySQL Multi-Source Replication enables a replication slave to
receive transactions from multiple sources simultaneously.
Multi-source replication can be used to back up multiple servers
to a single server, to merge table shards, and consolidate data
from multiple servers to a single server. Multi-source
replication does not implement any conflict detection or
resolution when applying the transactions, and those tasks are
left to the …
[Read more]