MySQL DB: Combo MyISAM and InnoDB is it doable, safe?

[nemini]

I am in a situation where I need to implement InnoDB transaction capability.
But this will call for ALTER a few tables of a DB previously set exclusively with MyISAM table engine.

Is there any problem to foresee while operating a DB with a mixed table engine combo made of MyISAM & InnoDB?

 

[ScottPrelewicz]

From MySQL manual:

You can combine transaction-safe and non-transaction-safe tables in the same statements to get the best of both worlds. However, although MySQL supports several transaction-safe storage engines, for best results, you should not mix different storage engines within a transaction with autocommit disabled.

See:

http://mikebernat.com/blog/MySQL_-_InnoDB_vs_MyISAM

Scott Prelewicz
Web Developer
COMAND Solutions

 

[nemini]

Thank you!