Re: InnoDB on master, MyISAM on slaves?

On Fri, Nov 21, 2003 at 01:15:52PM -0700, Matt Sturtz wrote: Thanks for the quick reply-- Yes, this is a common strategy, actually. Any tricks to getting the tables converted on the master without the slaves knowing about it (IE how can I do 'alter table' on the master without it being

InnoDB on master, MyISAM on slaves?

Hello, We run a master-slave configuration and are considering migrating a few tables to InnoDB to get transaction capability... Question is, can we keep the tables as MyISAM on the slaves to maintain the high-speed accesses? I suppose this would require the SQL not being written to the bin-log

Re: InnoDB on master, MyISAM on slaves?

At 11:36 -0700 11/21/03, Matt Sturtz wrote: Hello, We run a master-slave configuration and are considering migrating a few tables to InnoDB to get transaction capability... Question is, can we keep the tables as MyISAM on the slaves to maintain the high-speed accesses? I suppose this would

Re: InnoDB on master, MyISAM on slaves?

Thanks for the quick reply-- Yes, this is a common strategy, actually. Any tricks to getting the tables converted on the master without the slaves knowing about it (IE how can I do 'alter table' on the master without it being executed on the slaves)? Transactions are not written to the binary