Setting up Database Replication with multiple slaves

May 8, 2019 286 views
Databases Ubuntu 16.04

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?

1 Answer
bobbyiliev MOD June 10, 2019
Accepted Answer

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.

Have another answer? Share your knowledge.