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.

  • I suspect it will be replicated, since there is no other way to get the index built on the slave. It would be safe to simply try it; then if the FT index is missing on the slave, build it. Probably all DDL statements go as SBR even if you are running RBR. – Rick James Feb 20 '15 at 18:55

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.

| improve this answer | |
  • on master , i have fired create table , but it didnt replicated. i can see this command in binary log file but it is not replicated and replication has crossed the position of this statement – Ankit Kapoor Apr 13 '17 at 13:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.