Are CREATE INDEX statements replicated in row-based Mysql Replication?

Posted on

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.

Leave a Reply

Your email address will not be published. Required fields are marked *