The Ultimate Guide to High Availability with MariaDB

Mariadb Replication Question

You are viewing an old version of this question. View the current version here.

Hi All,

Very quick question when you have a moment. I have a setup with 9 masters and one 1 slave. I've been asked to move a database from one of the master mariadb server to another, as the server is under performing.

My question is, if I backup the Mariadb database and then delete the database on the master Mariadb, will this delete it from the replica slave?

Kind Regards, John

Answer Answered by Kristian Nielsen in this comment.

Yes, by default a DROP DATABASE xxx on the master will be replicated to the slave and delete the database there as well.

One way to avoid this is to disable binlogging for the DROP DATABASE, so that it does not participate in the replication, using sql_log_bin: <<code lang=mysql>> SET STATEMENT sql_log_bin=0 FOR DROP DATABASE xxx; <<code>> It is best to test this first by creating an extra empty database and test that it can be dropped on the master without affecting the slave.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.