Debian 12 bookworm
Sponsored Link

OpenStack Zed : Configure Trove (Control Node)2023/06/30

 
Install OpenStack Database Service (Trove).
This example is based on the environment like follows.
Install Trove services on Network Node.
------------+--------------------------+--------------------------+------------
            |                          |                          |
        eth0|10.0.0.30             eth0|10.0.0.50             eth0|10.0.0.51
+-----------+-----------+  +-----------+-----------+  +-----------+-----------+
|   [ dlp.srv.world ]   |  | [ network.srv.world ] |  |  [ node01.srv.world ] |
|     (Control Node)    |  |     (Network Node)    |  |     (Compute Node)    |
|                       |  |                       |  |                       |
|  MariaDB    RabbitMQ  |  |  Neutron L2/L3 Agent  |  |        Libvirt        |
|  Memcached  Nginx     |  |   Neutron Metadata    |  |      Nova Compute     |
|  Keystone   httpd     |  |     Open vSwitch      |  |    Neutron L2 Agent   |
|  Glance     Nova API  |  |     iSCSI Target      |  |      Open vSwitch     |
|  Neutron Server       |  |     Cinder Volume     |  |                       |
|  Neutron Metadata     |  |     Trove Services    |  |                       |
|  Cinder API           |  |         Nginx         |  |                       |
+-----------------------+  +-----------------------+  +-----------------------+

[1] Add users and others for Trove in Keystone.
# create [trove] user in [service] project

root@dlp ~(keystone)#
openstack user create --domain default --project service --password servicepassword trove

+---------------------+----------------------------------+
| Field               | Value                            |
+---------------------+----------------------------------+
| default_project_id  | d8b09d86ed7743039f92b2e542ea26c1 |
| domain_id           | default                          |
| enabled             | True                             |
| id                  | 3420e3e7f4484d40a3205b5f3bf33873 |
| name                | trove                            |
| options             | {}                               |
| password_expires_at | None                             |
+---------------------+----------------------------------+

# add [trove] user in [admin] role

root@dlp ~(keystone)#
openstack role add --project service --user trove admin
# create service entry for [trove]

root@dlp ~(keystone)#
openstack service create --name trove --description "OpenStack Database Service" database

+-------------+----------------------------------+
| Field       | Value                            |
+-------------+----------------------------------+
| description | OpenStack Database Service       |
| enabled     | True                             |
| id          | 0c549b8ee71547dd82393df650973d8e |
| name        | trove                            |
| type        | database                         |
+-------------+----------------------------------+

# define Trove API Host

root@dlp ~(keystone)#
export trove_api=network.srv.world
# create endpoint for [trove] (public)

root@dlp ~(keystone)#
openstack endpoint create --region RegionOne database public https://$trove_api:8779/v1.0/%\(tenant_id\)s

+--------------+---------------------------------------------------+
| Field        | Value                                             |
+--------------+---------------------------------------------------+
| enabled      | True                                              |
| id           | 665184c6d8f342b382b4b0747bded063                  |
| interface    | public                                            |
| region       | RegionOne                                         |
| region_id    | RegionOne                                         |
| service_id   | 0c549b8ee71547dd82393df650973d8e                  |
| service_name | trove                                             |
| service_type | database                                          |
| url          | https://network.srv.world:8779/v1.0/%(tenant_id)s |
+--------------+---------------------------------------------------+

# create endpoint for [trove] (internal)

root@dlp ~(keystone)#
openstack endpoint create --region RegionOne database internal https://$trove_api:8779/v1.0/%\(tenant_id\)s

+--------------+---------------------------------------------------+
| Field        | Value                                             |
+--------------+---------------------------------------------------+
| enabled      | True                                              |
| id           | b56c5c99d671435bb19bc0af36b11057                  |
| interface    | internal                                          |
| region       | RegionOne                                         |
| region_id    | RegionOne                                         |
| service_id   | 0c549b8ee71547dd82393df650973d8e                  |
| service_name | trove                                             |
| service_type | database                                          |
| url          | https://network.srv.world:8779/v1.0/%(tenant_id)s |
+--------------+---------------------------------------------------+

# create endpoint for [trove] (admin)

root@dlp ~(keystone)#
openstack endpoint create --region RegionOne database admin https://$trove_api:8779/v1.0/%\(tenant_id\)s

+--------------+---------------------------------------------------+
| Field        | Value                                             |
+--------------+---------------------------------------------------+
| enabled      | True                                              |
| id           | f1d21b47395b4f7a8764d07e95079b6c                  |
| interface    | admin                                             |
| region       | RegionOne                                         |
| region_id    | RegionOne                                         |
| service_id   | 0c549b8ee71547dd82393df650973d8e                  |
| service_name | trove                                             |
| service_type | database                                          |
| url          | https://network.srv.world:8779/v1.0/%(tenant_id)s |
+--------------+---------------------------------------------------+
[2] Add a User and Database on MariaDB for Trove.
root@dlp ~(keystone)#
mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 216
Server version: 10.11.3-MariaDB-1 Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database trove; 
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> grant all privileges on trove.* to trove@'localhost' identified by 'password'; 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on trove.* to trove@'%' identified by 'password'; 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges; 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit 
Bye
Matched Content