First time here? Check out the FAQ!
x

MySQL 5.7.9 multi source replication.

0 votes
asked by about MySQL Community Server
edited by

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.

1 Answer

0 votes
answered by (329k points)

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

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...