Confluence 6 Configuring the MySQL server

In this step, you will configure your MySQL database server.

Note: If you try to connect your confluence to a MySQL database server that already exists. We strongly recommend that you run the configuration steps in MySQL in accordance with the installation steps described below:

To configure the MySQL server:

1. To run the MySQL Installation Guide:
   2. If you are connecting confluence to an existing MySQL server, select Reconfigure instance (Reconfigure Instance).
   4. Select Advanced Configuration.
   6. Choose the appropriate MySQL server type (type of MySQL)that meets your hardware requirements. This configuration affects the size of the memory, disk, and CPU resources used by the MySQL server. Please refer to MySQL documentation for more information.
   8. To select only transactional databases (transactional database only), you need to select Use InnoDB as the default storage engine for your database.
      you have to be your confluence. Select the InnoDB storage engine. Using the MyISAM storage engine will make confluence not work properly.
   10. Set the settings for the InnoDB tablespace (InnoDB tablespace) (the default setting is acceptable).
   12. Set the approximate current number of concurrent connections to match the requirements you confluence use. You can use the option provided by default, or you can manually enter the number of connections that you want MySQL to accept. Please refer to MySQL documentation for more information.
   14. For the network option (networkingoptions), determine enable TCP/IP networking (enable TCP/IP networking) and enable Strict mode (Enable Strict Mo DE), the option is selected (the default is selected). Please refer to the Networking and server SQL modes documentation for more information.
   16. For the default set of character sets for the MySQL server, choose Best support for multilingualism (in other words, use the UTF-8 character set). character This option allows confluence to support all languages. Please refer to the contents of configuring Database Character Encoding for more information.
   18. A configuration selection for Windows. You can choose to install MySQL as a service or not. If your hardware service is only set up for MySQL servers, you might want to install MySQL as a service (installed as Windows service), which means that you can automatically start MySQL as a service. Please refer to MySQL documentation for more information.
       Note: If you choose not to install MySQL as a service for Windows, you need to make sure that your MySQL service has been started when your confluence is connected to the server.
   20. Select Modify security settings (Modify Settings) to set the access password for your MySQL server (root) account.
2. Edit the files on your MySQL server my.cnf (M in Window OS y.ini ). In the [mysqld] section of this file, modify the following parameters:
   (Refer to MySQL Option Files for my.cnf my.ini More configuration information about and modifications)
   Find the [mysqld] section and make some changes to the following parameters:
   • Set the server to use the UTF-8 character set:
     

     [mysqld]...character-set-server=utf8collation-server=utf8_bin...

   • Set the default storage engine to be InnoDB:
     

     [mysqld]...default-storage-engine=INNODB...

   • max_allowed_packetThe specified variable is set to 256M:
     

     [mysqld]...max_allowed_packet=256M...

   • Specify innodb_log_file_size that the variable is set to at least 2GB:
     

     [mysqld]...innodb_log_file_size=2GB...

   • Determining that the Sql_mode parameter is not specified as No_auto_value_on_zero
     

     // remove this if it existssql_mode = NO_AUTO_VALUE_ON_ZERO

   • Determines the isolation level of the global transaction is set to Read-committed.
     

     [mysqld]...transaction-isolation=READ-COMMITTED...

   • Check that the 2 binary log format is configured to use ' row-based ' for the log:
     

     [mysqld]...binlog_format=row...

4. Restart your MySQL database server and make sure your settings are in effect:
   • In Windows, select Window Server Management to start the service.
   • On Linux:
     • Run the following command, based on your settings: ' /etc/init.d/mysqld stop /etc/init.d/mysql stop or ' or ' service mysqld stop .
     • Rerun the command above and replace the command with " stop start ."
   • On Mac OS X, run ' sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart .

Https://www.cwiki.us/display/CONFLUENCEWIKI/Database+Setup+For+MySQL

Confluence 6 Configuring the MySQL server