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 source.
CREATE TABLE IF NOT EXISTSstatement without a
SELECTis replicated, whether or not the table already exists on the source. This includes
CREATE TABLE IF NOT EXISTS ... LIKE. Replication of
CREATE TABLE IF NOT EXISTS ... SELECTfollows somewhat different rules; see Section 4.1.7, “Replication of CREATE TABLE ... SELECT Statements”, for more information.
CREATE EVENT IF NOT EXISTSis always replicated in MySQL 5.6, whether or not the event named in the statement already exists on the source.
See also Bug #45574.