MySQL applies these rules when various CREATE ... IF
NOT EXISTS statements are replicated:
Every
CREATE DATABASE IF NOT EXISTSstatement is replicated, whether or not the database already exists on the master.Similarly, every
CREATE TABLE IF NOT EXISTSstatement without aSELECTis replicated, whether or not the table already exists on the master. This includesCREATE TABLE IF NOT EXISTS ... LIKE. Replication ofCREATE TABLE IF NOT EXISTS ... SELECTfollows somewhat different rules; see Section 17.4.1.4, “Replication ofCREATE TABLE ... SELECTStatements”, 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.