Overview

Sometimes, you need to have two tables with different engines replicating to each other. For example, memory table should have a shadow table(InnoDB or MyISAM), or you can have DML operations on the master (InnoDB) and report operation on the slave(MyISAM) Other example is to load data, for example, you can create a loading table(CSV + Blackhole) to replicate the data on the salve(InnoDB or MyISAM) In this case, it is best to have tables with the same data in different engines in order to use the pros of each engines.

Change of engine

The procedure itself it simple, on the target table: