Databáze SQL¶

Nainstalujte balíčky:

# 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
  max_connections = 4096
  collation-server = utf8_general_ci
  character-set-server = utf8
  

Spusťte službu databáze a nastavte ji, aby byla spuštěna při zavedení systému:

# 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