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
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:
-
-
1It 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 RixAug 14, 2012 at 8:07