Configuring Sakai to use MySQL is an excellent option both for local development and production purposes.
Sakai requires transaction support. In the case of MySQL you must implement the InnoDB storage engine to ensure proper transaction handling.
You will not need to create Sakai database objects (tables, indices, etc) when setting up your database. Sakai generates its own database schema automatically during the Tomcat setup process via the autoDDL setting in sakai.properties.
...
| No Format |
|---|
mysql Ver 14.14 Distrib 5.1.4652, for apple-darwin10.23.0 (i386) using readline 5.1 |
...