Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-55541

Improve MySQL schema creation to always specify InnoDB storage engine

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Since upgrading to Hibernate 5, Confluence can make Hibernate specify during schema creation that created tables should use InnoDB as their storage engine, no matter what the default storage engine of the MySQL has been configured to be. When this works, all CREATE TABLE DDL will have ENGINE=InnoDB appended. This will reduce setup and configuration pain when using MySQL.

      Note that Confluence must upgrade to Hibernate 5.2.9 or higher in order for this technique to work. Note also that if Confluence changes its mysql default Dialect to org.hibernate.dialect.MySQL55Dialect or a subclass, then Hibernate will default to specifying InnoDB automatically.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              richatkins Richard Atkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: