Question

Setting up Database Replication with multiple slaves

Posted May 8, 2019 1.1k views
Ubuntu 16.04 Databases

I’ve followed the instructions here to setup replication - it works great.

I need to add a second slave that only replicates one database from the master. How can I do this?

Add a comment
CMTiffani
By:
CMTiffani
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer
bobbyiliev June 10, 2019

You should be able to follow the same steps for the second replica, just try adding this in your second slave’s config: replicate_do_db = dbname, that way only this specific database should be replicated.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help