MyISAM to InnoDB migration
Hello,
I am using mysql version 5.0.77-log.
I have a critical database ABC of around 100 GB and I cant afford a downtime in my environment. Currently all the tables are in MyISAM engine and I need to convert them into InnoDB without any downtime.
If I go with the traditional method of taking a dump of the structure and then doing ALTER TABLE tablenmae ENGINE =INNODB and then dumping the data into the altered table structures; then it will cost me around 10 hrs of downtime which is simply not possible.
The other way I thought was simply putting the dump with altered table to INNODB into another new database XYZ but then changing database means lots of changes on the application side which uses database ABC at lot many places which also looks like a not a gud option.
Is there any other option available which can be used for migration without any downtime ?
Thanks in advance.
Please help
Subject
Views
Written By
Posted
MyISAM to InnoDB migration
4078
March 15, 2011 01:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.