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

Request to add Information to MySQL setup documenation

    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

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      This is a request to add some specific information on the MySQL Database Setup doc of Confluence.

      By following the documentation, the installation should work properly. However, there could have some specific cases that using MySQL 5.1.5+ with InnoDB and the default binary logging format - i.e. 'STATEMENT' could make it to not work properly, as we can see in this KB article.

      Something like the following:

      Remember that you must configure MySQL's binary logging format to use 'row-based' binary logging, in case of not having it yet:

      1. Shutdown Confluence and your MySQL database
      2. Open the MySQL configuration file (my.cnf) in a text editor
        On UNIX-based systems, this file may be located in the /etc directory
      3. Locate the binlog_format property in this file in the [mysqld] section and ensure that its value is row, such that you end up with:
        binlog_format=row
        
      4. Save your changes to this file
      5. Restart Confluence and your MySQL database

      Attachments

        Issue Links

          Activity

            People

              rrobins Rachel Robins
              gdecampos Giuliano C.
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: