[Building Sakai] InnoDB Question

[Sam Ottenhoff]

I strongly recommend using only InnoDB.  All tables should be InnoDB. 
Using only InnoDB will provide transaction support, foreign key support, 
and will make sure you are running on the same database engine as other 
Sakai MySQL users.

I recommend stopping Sakai, doing a MySQL database dump, changing all 
table creation stanzas to use InnoDB, and re-importing the database.  
Finally, I recommend starting a clean instance of Sakai 2.7 to compare 
it your newly-converted InnoDB database.  If you have any missing 
foreign keys in your converted database, you will have to resolve 
duplicate data manually and apply the foreign-key constraints manually.

--Sam

On 10/20/2010 8:31 PM, Bryan Bakotich wrote:
> 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
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101020/460396fa/attachment.html