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.
# zypper install mariadb-client mariadb python-PyMySQL
Create and edit the /etc/my.cnf.d/openstack.cnf
file
and complete the following actions:
Create a [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
default-storage-engine = innodb
innodb_file_per_table = on
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
# systemctl enable mysql.service
# systemctl start mysql.service
Secure the database service by running the mysql_secure_installation
script. In particular, choose a suitable password for the database
root
account:
# mysql_secure_installation
Except where otherwise noted, this document is licensed under Creative Commons Attribution 3.0 License. See all OpenStack Legal Documents.