Details
-
Task
-
Resolution: Unresolved
-
Neutral
-
None
-
None
-
None
-
-
Empty show more show less
-
Empty show more show less
Description
When using a MySQL database as persistent storage, you must use the InnoDB storage engine. InnoDB supports transactions. The other popular storage engine, MyISAM, is not transactional and won't work with Magnolia CMS. We don't stress this fact enough. Users often go with the default MyISAM storage engine, which leads to problems.
Document how to select the InnoDB storage engine using MySQL GUI tools and using the command line. Try to find existing procedures on the Web, ideally in official MySQL documentation, to avoid rewriting.
Link to the engine selection procedures from official Magnolia documentation and wiki articles such as Certified stack and Setting up Jackrabbit persistence manager. Look for other docs where MySQL setup is discussed. Make the reason and links prominent, for example with an info box.