In the replication topology I manage there are many layers of
replication filters that prune data at the database and in a
few places table level. The way MySQL replicates Data Definition Language (create, alter, drop)
statements differs from how Data Manipulation Language (insert, update,
delete) statements are handled with row-based replication. I
often need to fix broken replication due to a lack of
understanding of these subtle differences.
With row-based replication DML statements focus directly on the
table being modified. DDL on the other hand always uses
statement-based replication and is tied to what is known in MySQL
as the "default database". The default database is the
schema/database currently in use when a DDL …
Showing entries 1 to 1
Jun
03
2013
Showing entries 1 to 1