You are here: Supporting Documents > Stratus Cloud Installation Guide > OpenStack Installation and Configuration > MySQL Connections

MySQL Connections

To prevent errors in Heat and Horizon, Stratus recommends setting the number of MySQL connections to 300.

To set MySQL connections:

  1. Open the file /etc/my.cnf.
  2. In the /etc/my.cnf file in the [mysqld] section, add the parameter: max_connections = 300. The following is an example of the the /etc/my.cnf file containing the correct MySQL connection settings:

    [mysqld]

    datadir=/var/lib/mysql

    socket=/var/lib/mysql/mysql.sock

    user=mysql

    # Disabling symbolic-links is recommended to prevent assorted security risks

    symbolic-links=0

    default-storage-engine = innodb

    innodb_file_per_table

    collation-server = utf8_general_ci

    init-connect = 'SET NAMES utf8'

    character-set-server = utf8

    bind-address = 0.0.0.0

    max_connections = 300

  3. Save and close the /etc/my.cnf file.
  4. Restart mysqld using the command service mysqld restart.

of