Question :
I’ve not been able to find a simple explanation of what kinds of statements are or are not replicated from a master db to a slave in MySQL, row-based replication. Specifically I want to add a fulltext index to a table and am wondering if i’ll have to do that on each slave too or if that will get replicated.
Answer :
DDL can still replicate with row-based replication
From the MySQL Documentation for binlog-do-db
For example, DDL statements such as CREATE TABLE and ALTER TABLE are always logged as statements, without regard to the logging format in effect
Since CREATE INDEX is mapped to ALTER TABLE, CREATE INDEX
will work just fine.