SQL database¶

Install the packages:

# yum install mariadb mariadb-server MySQL-python

Create and edit the /etc/my.cnf.d/mariadb_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
  

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

# systemctl enable mariadb.service
# systemctl start mariadb.service