Hi Gary, On Dec 6, 2007 10:56 AM, Gary W. Smith <[EMAIL PROTECTED]> wrote: > 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).
You can set the default storage engine on each of the servers and then don't declare it explicitly in any CREATE TABLE statements. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
