16.4.1.5 Replication of CREATE ... IF NOT EXISTS Statements
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 source.Similarly, every
CREATE TABLE IF NOT EXISTSstatement without aSELECTis replicated, whether or not the table already exists on the source. This includesCREATE TABLE IF NOT EXISTS ... LIKE. Replication ofCREATE TABLE IF NOT EXISTS ... SELECTfollows somewhat different rules; see Section 16.4.1.6, “Replication of CREATE TABLE ... SELECT Statements”, for more information.CREATE EVENT IF NOT EXISTSis always replicated, whether or not the event named in the statement already exists on the source.