How do I?

User Tools

Site Tools

You are here: start » cloud » recipe » sql_service
cloud:recipe:sql_service

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
cloud:recipe:sql_service [2021/04/15 16:11] – trim language chudlercloud:recipe:sql_service [2021/04/15 17:22] (current) – [MySQL Usage Example] chudler
Line 2: Line 2:
  
 ===SETUP LOCAL ENVIRONMENT FIRST=== ===SETUP LOCAL ENVIRONMENT FIRST===
 +
 +For Cloud access, see the [[ cloud:intro | Intro Guide]].
  
 To bootstrap your local environment, see the **Configuration** and **Usage** sections of the [[ cloud:cli | CLI document]]. To bootstrap your local environment, see the **Configuration** and **Usage** sections of the [[ cloud:cli | CLI document]].
  
-For Cloud access, see the [[ cloud:intro | Intro Guide]]. 
  
 In addition to the ''openstack client'', you must also install the Trove client in order to interact with the database service. In addition to the ''openstack client'', you must also install the Trove client in order to interact with the database service.
Line 40: Line 41:
 # openstack network list # openstack network list
 +--------------------------------------+--------------------+--------------------------------------+ +--------------------------------------+--------------------+--------------------------------------+
-| ID                                   | Name               | Subnets                              | +| ID                                   | Name     | Subnets                              | 
-+--------------------------------------+--------------------+--------------------------------------+ ++--------------------------------------+----------+--------------------------------------+ 
-| 31ad6cfa-e586-45fc-91aa-819e53b89c04 | curry              | 70d8751b-767a-4ca5-bae3-993b0012020b | +| 3f510b67-d623-44fe-8e35-e6e2beb9dfb5 | cloud    | 9d2c428a-14b7-4820-aeca-57fe3faaae0b | 
-| 3f510b67-d623-44fe-8e35-e6e2beb9dfb5 | cloud              | 9d2c428a-14b7-4820-aeca-57fe3faaae0b | +| b5d53de5-9ebe-4166-950e-957d4f2507de | campus37 | e4c5c059-616b-4321-b8fd-72510f4b7c5e | 
-| b5d53de5-9ebe-4166-950e-957d4f2507de | campus37           | e4c5c059-616b-4321-b8fd-72510f4b7c5e | ++--------------------------------------+----------+--------------------------------------+
-+--------------------------------------+--------------------+--------------------------------------++
 </code> </code>
  
Line 87: Line 87:
 +--------------------------+-----------------------------------------+ +--------------------------+-----------------------------------------+
 | allowed_cidrs            | ['128.135.164.0/24', '10.135.164.0/24'] | | allowed_cidrs            | ['128.135.164.0/24', '10.135.164.0/24'] |
-| created                  | 2019-06-21T15:26:04                     |+| created                  | 2021-04-15T22:18:07                     |
 | datastore                | mysql                                   | | datastore                | mysql                                   |
 | datastore_version        | 5.7.29                                  | | datastore_version        | 5.7.29                                  |
 | datastore_version_number | None                                    | | datastore_version_number | None                                    |
-| encrypted_rpc_messaging  | True                                    | 
 | flavor                   | 8c70c6f6-0608-415e-8674-ed948d8a3387    | | flavor                   | 8c70c6f6-0608-415e-8674-ed948d8a3387    |
-| id                       | 0a5a73d0-fc83-4873-9b33-118461f3064c    |+| id                       | 1d53f400-b3ec-4b08-90e0-6b7b48c8e7c5    |
 | name                     | mydb                                    | | name                     | mydb                                    |
 | public                   | False                                   | | public                   | False                                   |
 | region                   | RegionOne                               | | region                   | RegionOne                               |
-| server_id                | 0657840f-6378-437b-9741-f908464f8358    | +| service_status_updated   | 2021-04-15T22:18:07                     |
-| service_status_updated   | 2019-06-21T15:26:04                     |+
 | status                   | BUILD                                   | | status                   | BUILD                                   |
-| tenant_id                | f6f2d3457ef447ed96f7a3e8b7ffcd41        | +| updated                  | 2021-04-15T22:18:24                     |
-| updated                  | 2019-06-21T15:26:17                     |+
 | volume                   | 10                                      | | volume                   | 10                                      |
-| volume_id                | 2b45febc-eabc-436d-b28b-da05c19efeb7    | 
 +--------------------------+-----------------------------------------+ +--------------------------+-----------------------------------------+
 </code> </code>
  
-Note that your instance **status** is set to **BUILD** until the database is ready. This output also includes the __server_id__ which is crucial for troubleshooting, and shows how your database is backed by an on-demand virtual instance.+Note that your instance **status** is set to **BUILD** until the database is ready. Your database is backed by an on-demand virtual instance.
  
 When the database instance status chances to **HEALTHY**, you can connect to your database using the IP address that is shown in the ouput: When the database instance status chances to **HEALTHY**, you can connect to your database using the IP address that is shown in the ouput:
/var/lib/dokuwiki/data/attic/cloud/recipe/sql_service.1618521061.txt.gz · Last modified: 2021/04/15 16:11 by chudler
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki