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
