[DOCU-250] MySQL InnoDB storage engine Created: 07/Feb/12 Updated: 03/Nov/15 |
|
| Status: | Closed |
| Project: | Documentation |
| Component/s: | content |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Neutral |
| Reporter: | Antti Hietala | Assignee: | Antti Hietala |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Template: |
|
| Acceptance criteria: |
Empty
|
| Task DoR: |
Empty
|
| Date of First Response: |
| 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. |
| Comments |
| Comment by Matt Dertinger [ 07/Feb/12 ] |
|
Hi, In addition to documenting how to select the InnoDB storage engine when first installing Magnolia CMS, it may be helpful to document how to convert an existing installation that's using MyISAM to InnoDB. It should also be mentioned that InnoDB is now the default storage engine as of MySQL 5.5. A handy way to convert existing tables from MyISAM to InnoDB is to do the following:
Some helpful resources for converting existing tables from MyISAM to InnoDB can be found here:
Cheers, |
| Comment by Antti Hietala [ 08/Jan/13 ] |
|
Linked to Setting the Storage Engine from: |