适用于 Red Hat Enterprise Linux 和 CentOS 的安装和配置

本节描述了如何在 Red Hat Enterprise Linux 9 和 CentOS Stream 9 上安装和配置数据库服务。

先决条件

在安装和配置数据库服务之前,您必须创建一个数据库、服务凭证和 API 端点。

  1. 要创建数据库,请完成以下步骤

    • 使用数据库访问客户端以 root 用户身份连接到数据库服务器

      $ mysql -u root -p
      
    • 创建 trove 数据库

      CREATE DATABASE trove;
      
    • 授予对 trove 数据库的适当访问权限

      GRANT ALL PRIVILEGES ON trove.* TO 'trove'@'localhost' \
        IDENTIFIED BY 'TROVE_DBPASS';
      GRANT ALL PRIVILEGES ON trove.* TO 'trove'@'%' \
        IDENTIFIED BY 'TROVE_DBPASS';
      

      TROVE_DBPASS 替换为合适的密码。

    • 退出数据库访问客户端。

  2. 激活 admin 凭证以访问仅管理员可用的 CLI 命令

    $ . admin-openrc
    
  3. 要创建服务凭证,请完成以下步骤

    • 创建 trove 用户

      $ openstack user create --domain default --password-prompt trove
      User Password:
      Repeat User Password:
      +-----------+-----------------------------------+
      | Field     | Value                             |
      +-----------+-----------------------------------+
      | domain_id | default                           |
      | enabled   | True                              |
      | id        | ca2e175b851943349be29a328cc5e360  |
      | name      | trove                             |
      +-----------+-----------------------------------+
      
    • admin 角色添加到 trove 用户

      $ openstack role add --project service --user trove admin
      

      注意

      此命令不会产生任何输出。

    • 创建 trove 服务实体

      $ openstack service create --name trove \
        --description "Database" database
      +-------------+-----------------------------------+
      | Field       | Value                             |
      +-------------+-----------------------------------+
      | description | Database                          |
      | enabled     | True                              |
      | id          | 727841c6f5df4773baa4e8a5ae7d72eb  |
      | name        | trove                             |
      | type        | database                          |
      +-------------+-----------------------------------+
      
  4. 创建数据库服务 API 端点

    $ openstack endpoint create --region RegionOne \
      database public http://controller:8779/v1.0/%\(tenant_id\)s
    +--------------+----------------------------------------------+
    | Field        | Value                                        |
    +--------------+----------------------------------------------+
    | enabled      | True                                         |
    | id           | 3f4dab34624e4be7b000265f25049609             |
    | interface    | public                                       |
    | region       | RegionOne                                    |
    | region_id    | RegionOne                                    |
    | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
    | service_name | trove                                        |
    | service_type | database                                     |
    | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
    +--------------+----------------------------------------------+
    
    $ openstack endpoint create --region RegionOne \
      database internal http://controller:8779/v1.0/%\(tenant_id\)s
    +--------------+----------------------------------------------+
    | Field        | Value                                        |
    +--------------+----------------------------------------------+
    | enabled      | True                                         |
    | id           | 9489f78e958e45cc85570fec7e836d98             |
    | interface    | internal                                     |
    | region       | RegionOne                                    |
    | region_id    | RegionOne                                    |
    | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
    | service_name | trove                                        |
    | service_type | database                                     |
    | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
    +--------------+----------------------------------------------+
    
    $ openstack endpoint create --region RegionOne \
      database admin http://controller:8779/v1.0/%\(tenant_id\)s
    +--------------+----------------------------------------------+
    | Field        | Value                                        |
    +--------------+----------------------------------------------+
    | enabled      | True                                         |
    | id           | 76091559514b40c6b7b38dde790efe99             |
    | interface    | admin                                        |
    | region       | RegionOne                                    |
    | region_id    | RegionOne                                    |
    | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
    | service_name | trove                                        |
    | service_type | database                                     |
    | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
    +--------------+----------------------------------------------+
    

安装和配置组件

  1. 安装软件包

    # dnf install openstack-trove python3-troveclient
    
  1. /etc/trove 目录中,编辑 trove.conf 文件,这里是一个示例

    [DEFAULT]
    network_driver = trove.network.neutron.NeutronDriver
    management_networks = ef7541ad-9599-4285-878a-e0ab62032b03
    management_security_groups = d0d797f7-11d4-436e-89a3-ac8bca829f81
    cinder_volume_type = lvmdriver-1
    nova_keypair = trove-mgmt
    default_datastore = mysql
    taskmanager_manager = trove.taskmanager.manager.Manager
    trove_api_workers = 5
    transport_url = rabbit://stackrabbit:password@192.168.1.34:5672/
    control_exchange = trove
    reboot_time_out = 300
    usage_timeout = 900
    agent_call_high_timeout = 1200
    use_syslog = False
    debug = True
    
    [keystone_authtoken]
    memcached_servers = localhost:11211
    cafile = /devstack/stack/data/ca-bundle.pem
    project_domain_name = Default
    project_name = service
    user_domain_name = Default
    password = password
    username = trove
    auth_url = http://192.168.1.34/identity
    auth_type = password
    
    [service_credentials]
    auth_url = http://192.168.1.34/identity/v3
    region_name = RegionOne
    project_name = service
    password = password
    project_domain_name = Default
    user_domain_name = Default
    username = trove
    
    [database]
    connection = mysql+pymysql://root:password@127.0.0.1/trove?charset=utf8
    
    [mariadb]
    tcp_ports = 3306,4444,4567,4568
    
    [mysql]
    tcp_ports = 3306
    
    [postgresql]
    tcp_ports = 5432
    
  2. 验证 api-paste.ini 文件是否存在于 /etc/trove 中。

    如果文件不存在,您可以从 此处 获取它。

  3. 编辑 /etc/trove/trove-guestagent.conf 文件,以便未来的 trove 客户机可以连接到您的 OpenStack 环境,这里是一个示例

    [DEFAULT]
    log_file = trove-guestagent.log
    log_dir = /var/log/trove/
    ignore_users = os_admin
    control_exchange = trove
    transport_url = rabbit://stackrabbit:password@172.24.5.1:5672/
    command_process_timeout = 60
    use_syslog = False
    debug = True
    
    [service_credentials]
    auth_url = http://192.168.1.34/identity/v3
    region_name = RegionOne
    project_name = service
    password = password
    project_domain_name = Default
    user_domain_name = Default
    username = trove
    
  4. 填充您之前在本过程中创建的 trove 数据库

    # su -s /bin/sh -c "trove-manage db_sync" trove
      ...
      2016-04-06 22:00:17.771 10706 INFO trove.db.sqlalchemy.migration [-]
      Upgrading mysql+pymysql://trove:dbaasdb@controller/trove to version latest
    

    注意

    忽略此输出中的任何弃用消息。

完成安装

启动数据库服务并配置它们在系统启动时启动

# systemctl enable openstack-trove-api.service \
  openstack-trove-taskmanager.service \
  openstack-trove-conductor.service

# systemctl start openstack-trove-api.service \
  openstack-trove-taskmanager.service \
  openstack-trove-conductor.service