MySQL applies these rules when various
CREATE ... IF
NOT EXISTS statements are replicated:
CREATE DATABASE IF NOT EXISTSstatement is replicated, whether or not the database already exists on the master.
CREATE TABLE IF NOT EXISTSstatement without a
SELECTis replicated, whether or not the table already exists on the master. This includes
CREATE TABLE IF NOT EXISTS ... LIKE. Replication of
CREATE TABLE IF NOT EXISTS ... SELECTfollows somewhat different rules; see Section 18.104.22.168, “Replication of CREATE TABLE ... SELECT Statements”, for more information.
CREATE EVENT IF NOT EXISTSis always replicated in MySQL 5.5, whether or not the event named in the statement already exists on the master.
See also Bug #45574.