Am 25. Jul, 2010 schwätzte Alex Dean so:
>
> 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).
Something like this is how the other tables got converted, but one big
table got overlooked. We've already converted the slave and want to avoid
another slave->master->slave dance.
I think I can make it happen with some log parsing and some incremental
updates.
ciao,
der.hans
--
# http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/
# Director of Engineering, FonWallet Transaction Solutions, Inc.
# As we enjoy great Advantages from the
# Inventions of others we should be glad of an
# Opportunity to serve others by any Invention of ours,
# and this we should do freely and generously.
# -- Benjamin Franklin (1706-1790), on his refusal to patent his inventions.
---------------------------------------------------
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
(text/plain)