...
| Code Block | ||
|---|---|---|
| ||
$ openstack database instance show <id-of-the-database-instance>
+--------------------------+-----------------------------------------------------------------------------------------------------+
| Field | Value |
+--------------------------+-----------------------------------------------------------------------------------------------------+
| addresses | [{'address': 'xx.xx.xx.xx', 'type': 'private'}, {'address': 'xx.xx.xx.xx', 'type': 'public'}] |
| allowed_cidrs | ['xx.xx.xx.xx/y', 'xx.xx.xx.xx/y'] |
| created | 2023-06-09T09:19:11 |
| datastore | mysql |
| datastore_version | 5.7.29 |
| datastore_version_number | 5.7.29 |
| flavor | 7595d735-6de4-415f-a958-838089a09080 |
| id | --- the ID of the DB instance |
| ip | xx.xx.xx.xx, xx.xx.xx.xx |
| name | MyTroveDB |
| operating_status | HEALTHY |
| public | True |
| region | RegionOne |
| service_status_updated | 2023-06-09T09:22:21 |
| status | ACTIVE |
| updated | 2023-06-09T09:20:48 |
| volume | 10 |
| volume_used | 0.22 |
+--------------------------+-----------------------------------------------------------------------------------------------------+ |
You need to use the IP address assigned to the database. Also, check the status and the operating_status. If the status is ACTIVE, then the database instance is ready to use.
It may takes some time to get the database instance in ACTIVE state after being created.
To access the created database you can refer to dedicated section.
...