SQL database

SQL database

Most OpenStack services use an SQL database to store information. The database typically runs on the controller node. The procedures in this guide use MariaDB or MySQL depending on the distribution. OpenStack services also support other SQL databases including PostgreSQL.

Install and configure components

  1. Install the packages:

    # pkg install mysql57-server py27-pymysql
    
  1. Edit the /usr/local/etc/mysql/my.cnf file and complete the following actions:

    • In [mysqld] section, and set the bind-address key to the management IP address of the controller node to enable access by other nodes via the management network. Set additional keys to enable useful options and the UTF-8 character set:

      [mysqld]
      bind-address = 10.0.0.11
      

Finalize installation

  1. Start the database service and configure it to start when the system boots:

    # sysrc mysql_enable="YES"
    # service mysql-server start
    
  1. Secure the database service by changing the root password for the database root account.

    $ cat ~/.mysql_secret
    $ mysql -u root -p
    
    mysql> SET PASSWORD='MYSQL_PASSWORD'
    
Creative Commons Attribution 3.0 License

Except where otherwise noted, this document is licensed under Creative Commons Attribution 3.0 License. See all OpenStack Legal Documents.