Hey all,
I've got a production database that made up of all MyISAM tables. I'd
like to change some of the more heavily written to tables to InnoDB to
take advantage of the record level locking and thus improve write
performance of our applications.
I currently have a second db server that is replicating from the current
production system but not in production yet. I'd like to try to convert
it to InnoDB. MySQL version is 4.0.16. It it as symple as just issuing
the modify table query or are there problems I should be aware of when
doing this?
Also are there known problems replicating from A -> B -> A (circular
replication) when A had Table1= InnoDB and B has Table1=MyISAM?
Thanks,
Jeff
