MySQL grant use?

[der.hans]

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.