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¶

Install the packages:

# apt-get install mariadb-server python-pymysql

Choose a suitable password for the database root account.
Create and edit the /etc/mysql/conf.d/mysqld_openstack.cnf file and complete the following actions:
- In the [mysqld] section, set the bind-address key to the management IP address of the controller node to enable access by other nodes via the management network:
```
[mysqld]
...
bind-address = 10.0.0.11
```
- In the [mysqld] section, set the following keys to enable useful options and the UTF-8 character set:
```
[mysqld]
...
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
```

Finalize installation¶

Restart the database service:
```
# service mysql restart
```

Secure the database service by running the mysql_secure_installation script.

SQL database

Contents

SQL database¶

Install and configure components¶

Finalize installation¶

Contents