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 …