SQL database for Ubuntu

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.

备注

As of Ubuntu 16.04, MariaDB was changed to use the "unix_socket Authentication Plugin". Local authentication is now performed using the user credentials (UID), and password authentication is no longer used by default. This means that the root user no longer uses a password for local access to the server.

备注

As of Ubuntu 18.04, the mariadb-server package is no longer available from the default repository. To install successfully, enable the Universe repository on Ubuntu.

安装并配置组件

1. 安装软件包：

   • As of Ubuntu 20.04, install the packages:

     # apt install mariadb-server python3-pymysql
     

   • As of Ubuntu 18.04 or 16.04, install the packages:

     # apt install mariadb-server python-pymysql
     

2. 创建并编辑"/etc/mysql/mariadb.conf.d/99-openstack.cnf"文件并完成下列行为：

   • 在[mysqld]中，设置“bind-address”值为控制节点的管理网络IP地址以是的其他节点可以通过管理网络访问访问数据库。设置其他关键字来设置一些有用的选项和UTF-8编码：

     [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
     

完成安装

1. 重启数据库服务：

   # service mysql restart
   

2. 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