[Building Sakai] InnoDB Question

[Bryan Bakotich]

Hi,

On the Sakai 2.7 install guide it says this about MySQL and InnoDB: Sakai
requires transaction support. In the case of MySQL you must implement the
InnoDB storage engine to ensure proper transaction handling.

Does this mean that InnoDB just needs to be an available storage engine or
should this be the default storage engine so that all tables are InnoDB? I
am asking this because our current 2.6.x database is a mix of MyISAM and
InnoDB and I just ran into an error while running the
sakai_2_7_0_mysql_conversion.sql script because one of our existing tables
was MyISAM and it needed to be InnoDB.
I also recently did a fresh 2.7 install for a non-profit and their database
has a lot more InnoDB tables than ours (Our current installation has 118,
fresh install has 199).

So should all tables be InnoDB or just a few? Is it documented anywhere what
tables should be what storage engine so I can make sure our database is
correct? Thanks for the help!

-Bryan

-- 
Bryan Bakotich
Open Source Implementation Specialist
Digital Media Center, Information & Technology Services
Pacific Lutheran University
Tacoma, WA 98447-0013
Phone: 253-536-5021
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101020/c53b2bff/attachment.html