MySQL 5.7.9 multi source replication.

Question

I am trying to make multi-source MySQL replication. But I need to replicate only one database to one slave instance and other database to other slave instance. If I use replicate-do-db in master it replicates two databases to both slaves. Please suggest me any other way to replicate different databases.

Answer 1

The official website of MySQL provides an in-depth guide and tutorials on how to establish MySQL replication. Access the page listed below to learn how to do it properly without errors. This is the best way because you have the information directly from the developers and you can be sure that it will work under the given situation. Follow the instructions on the page and adjust the data according to your databases.

Tutorials page: https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-tutorials.html