MySQL Forums
Forum List  »  Replication

Unable to add database to slave
Posted by: Jørn Dahl-Stamnes
Date: May 10, 2019 06:11AM


I have a MariaDb master-slave setup. I'm trying to add a new database to both, but the slave is not willing to replicate.

What I did was:

slave> stop slave;
slave> flush tables;
slave> create database newdatabase;

Edited the config and added:
replication_do_db = 'newdatabase'

Then on master:
master> create database newdatabase;

Then I restarted the slave.
When I do a 'show slave status\G' I get:

Replacte_Do_Db: OldDb1, OldDb2, OldDb3

but not the new database.

Any suggestions?

Options: ReplyQuote

Written By
Unable to add database to slave
May 10, 2019 06:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.