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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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: