Related

Product Managed MySQL, Redis, Postgres on DigitalOcean Product
How to connect my ubuntu 16.04 vm to mysql database of another server? Question Question
PHP Error Log: authz_core:error - For files that don't exists on my server Question Question

Question

Setting up Database Replication with multiple slaves

Posted May 8, 2019 3.1k views
Ubuntu 16.04Databases

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

Related

Product Managed MySQL, Redis, Postgres on DigitalOcean Product
How to connect my ubuntu 16.04 vm to mysql database of another server? Question Question
PHP Error Log: authz_core:error - For files that don't exists on my server Question Question

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