I'd like to use InnoDB on the master, for its transactional ability, but MyISAM on the slaves for the full-text search ability. Is this possible?

1 Answer 1


Absolutely !!!

Just run ALTER TABLE tblname ENGINE=MyISAM; against all tables on the Slave that you want to have the FULLTEXT index. Afterwards, you can run ALTER TABLE tblname ADD FULLTEXT (column[,column]);.

Please be very careful not to run DDL against those tables in the Master that are unique to InnoDB that will replicate to the Slave.

I have suggested using a different Storage Engine on a Slave in my past posts:

  • Good news! You are the man Rolando. Aug 14, 2012 at 2:59
  • 1
    It works great, I have a syslog system, where the master collects data into the BLACKHOLE storage engine, which then off-loads all the heavy lifting to the slave running combinations of MyISAM and InnoDB. This way I can pause the slave in order to analyse the data, leaving the master collecting and only using log storage :)
    – Dave Rix
    Aug 14, 2012 at 8:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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