Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCU-250

MySQL InnoDB storage engine

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Neutral
    • None
    • None
    • content
    • None

    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.

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              ahietala Antti Hietala
              ahietala Antti Hietala
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Checklists

                  Task DoR