On Jul 25, 2010, at 3:03 AM, der.hans wrote:
I'm needing to convert a very busy production myisam table that is somewhat humongous to innodb and the conversion takes longer than the maintenance windows.
If you have a slave which is capable of becoming a production server, you can convert the slave to innodb. Let the conversion process take as long as it needs. Master is stil myisam, and slave is now innodb. Then during maintainence window, you take down the master and bind its IPs to the slave. Now you master is innodb. Needs testing, of course, but I believe this would work just fine. If you then set up the old master as a slave to the new master, you'll be able to switch back to using myisam on your master (as a saftey net).
alex --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
