MySQL applies these rules when various CREATE ... IF
NOT EXISTS
statements are replicated:
Every
CREATE DATABASE IF NOT EXISTS
statement is replicated, whether or not the database already exists on the master.Similarly, every
CREATE TABLE IF NOT EXISTS
statement without aSELECT
is replicated, whether or not the table already exists on the master. This includesCREATE TABLE IF NOT EXISTS ... LIKE
. Replication ofCREATE TABLE IF NOT EXISTS ... SELECT
follows somewhat different rules; see Section 17.4.1.4, “Replication ofCREATE TABLE ... SELECT
Statements”, for more information.CREATE EVENT IF NOT EXISTS
is always replicated in MySQL 5.5, whether or not the event named in the statement already exists on the master.
See also Bug#45574.