CentOS 8
Sponsored Link

OpenStack Victoria : Configure Trove (Control Node)2020/11/20

 
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
+-----------+-----------+   +-----------+-----------+   +-----------+-----------+
|    [ Control Node ]   |   |    [ Network Node ]   |   |    [ Compute Node ]   |
|                       |   |                       |   |                       |
|  MariaDB    RabbitMQ  |   |      Open vSwitch     |   |        Libvirt        |
|  Memcached  httpd     |   |        L2 Agent       |   |     Nova Compute      |
|  Keystone   Glance    |   |        L3 Agent       |   |      Open vSwitch     |
|  Nova API             |   |     Metadata Agent    |   |        L2 Agent       |
|  Neutron Server       |   |     Cinder Volume     |   |                       |
|  Metadata Agent       |   |   Heat API   API-CFN  |   |                       |
|  Cinder API           |   |   Heat Engine         |   |                       |
|                       |   |   Trove Services      |   |                       |
+-----------------------+   +-----------------------+   +-----------------------+

[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  | 4e42859fe8704e8aaddb5369551b6c52 |
| domain_id           | default                          |
| enabled             | True                             |
| id                  | 9c592a079d0e4cc297e1dbca18745f88 |
| 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          | 2e87c4a364b948f3a008992a0b388ee3 |
| name        | trove                            |
| type        | database                         |
+-------------+----------------------------------+

# define Trove API Host

[root@dlp ~(keystone)]#
export trove_api=10.0.0.50
# create endpoint for [trove] (public)

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

+--------------+------------------------------------------+
| Field        | Value                                    |
+--------------+------------------------------------------+
| enabled      | True                                     |
| id           | f6b49c764f664d6ca8ca2eb21fb63ab3         |
| interface    | public                                   |
| region       | RegionOne                                |
| region_id    | RegionOne                                |
| service_id   | 2e87c4a364b948f3a008992a0b388ee3         |
| service_name | trove                                    |
| service_type | database                                 |
| url          | http://10.0.0.50:8779/v1.0/%(tenant_id)s |
+--------------+------------------------------------------+

# create endpoint for [trove] (internal)

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

+--------------+------------------------------------------+
| Field        | Value                                    |
+--------------+------------------------------------------+
| enabled      | True                                     |
| id           | f877434166074ee6b224fe67f9b99f49         |
| interface    | internal                                 |
| region       | RegionOne                                |
| region_id    | RegionOne                                |
| service_id   | 2e87c4a364b948f3a008992a0b388ee3         |
| service_name | trove                                    |
| service_type | database                                 |
| url          | http://10.0.0.50:8779/v1.0/%(tenant_id)s |
+--------------+------------------------------------------+

# create endpoint for [trove] (admin)

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

+--------------+------------------------------------------+
| Field        | Value                                    |
+--------------+------------------------------------------+
| enabled      | True                                     |
| id           | 7c5bcebbf2bd4efb87df0000668eddae         |
| interface    | admin                                    |
| region       | RegionOne                                |
| region_id    | RegionOne                                |
| service_id   | 2e87c4a364b948f3a008992a0b388ee3         |
| service_name | trove                                    |
| service_type | database                                 |
| url          | http://10.0.0.50:8779/v1.0/%(tenant_id)s |
+--------------+------------------------------------------+
[2] Add a User and Database on MariaDB for Trove.
[root@dlp ~(keystone)]#
mysql -u root -p

Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 94
Server version: 10.3.17-MariaDB MariaDB Server

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