We have a master/master environment that has tables in innodb. We want to setup a slave that will be used for reporting and some other stuff as well. We want to use MyISAM as the engine on the slave'd server.

Since all of the table creations are also part of the replication, is it possible to override the table creates and force them to use a different engine? I have read a few articles on implementing the blackhole engine (for intermediate replication) which would be useful for us when we setup the replication to multiple sites, but this leads to the same question of how to change the engine (which isn't explained in the sample articles I've read).

Any help would be greatly appreciated.

Gary Wayne Smith