According to the replication documentation from MySQL, it is possible to set up replication from InnoDB source tables to MyISAM destination tables. Unfortunately, the documentation has little to say about drawbacks, data consistency implications (apart from the CASCADE corner case) and recommended settings for enabling such a replication configuration. So just a number of questions come to my mind regarding this setup:
- is statement-based replication preferred over the row-based variant or vice-versa?
- does either the InnoDB or the MyISAM side need some specific settings so data consistency would not break all by itself as the result of "normal" replication activity?
- are DDL executions on the master handled on the slave in a sane manner?
- how would I prevent an
ALTER TABLE blah ENGINE=InnoDBstatement run at the master from propagating to the slave?
- Is there a recommended way of setting up such a "split" setup? I could think of a direct
ALTER TABLE blah ENGINE=MyISAMon the slave, is this viable?
- any other caveats one should know about?