Comments - Mariadb Replication Question
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.
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.