we have a master-slave mysql replication setup.
The master has multiple databases and they get created and dropped, fairly often.
I would like to restrict the slave to not drop the databases. I couldn't find any such option on the mysql help page.
We provide a Saas model erp application and maintain each customer in a different database. After the trial period expires we delete databases from the master regularly(after backing up of course). Only lost a disk once and lost a few of those databases.
Mysql Replication– restricting drop database statements
mysql-replication
Best Answer
You can prevent certain commands from being written to the binlog, and thus prevent them from being replicatd, by doing
in the current session. See more at:
http://dev.mysql.com/doc/refman/5.7/en/set-sql-log-bin.html
Make sure the connection you do this on is not used for other purposes (eg from within a connection pool), since no commands in it will be written do the binlog until you do
or the connection is reestablished.