MySQL Database Best Practices

For best results, configure and maintain your MySQL database according to the vendor's requirements and use the Jive best practices.

UTF-8 Requirement

Jive requires the UTF-8 character set. Use the following steps to ensure it's correctly set up:
  1. Use the following command to set the database default character set to UTF-8:

    ALTER DATABASE jivecoredb DEFAULT CHARACTER SET utf8;

  2. After installation, add the following to the <database> section of the jive_startup.xml file:
     <mysql><useUnicode>true</useUnicode></mysql>
    Ensure that the Character Set setting in the Admin Console under System > Management > Locale is set to UTF-8.

Other Best Practices

Default configuration can vary significantly by version, so it is important to consider the following: