| Warning |
|---|
You have tried to access an archived page. Please go to the new https://root360.atlassian.net/wiki/spaces/KB to find more documents. |
Table of contents
| Table of Contents | ||
|---|---|---|
|
General usage instructions
...
Step-by-step guide
Show help context
...
...
Usage of r3 db show
| Code Block | ||
|---|---|---|
| ||
~$ r3 db show -h
# Response
Show Details for Snapshots/Database Servers of this Environment.
optional arguments:
-h, --help show this help message and exit
--loglevel {INFO,ERROR}
Define Loglevel for Execution (default: INFO)
--db-id DB_ID Show Details of Database Server.
--snapshot-id SNAPSHOT_ID
Show Details of Snapshots. |
| Info | |
|---|---|
| title | Environment SupportYou can use the optional argument --environment to list resource from the environment you are in (default) and also other environments. E.g. if you logged into your prod-System of project A, you can also list Databases and Snapshots from your test-Environment of project A (projectuser@root360-service-prod-natgw-i-xxx:~$ r3 db list --environment test). However, you are not able to list resources belonging to other projects, e.g. project B. |
Show database details
Obtain a Database Identifier from Resource Listing
Provide the Database Identifier to the r3 db show command using the categorizing argument --db-id
Database details example
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
~$ r3 db show --db-id rrgl3r5qn68j1 # Response Project: service Company: root360 Environment: prod +-----------------------------------------------------------+--------+---------------+---------+-------------+------------------+-----------------------+-----------+------------------+--------------------+ | Endpoint | Engine | EngineVersion | MultiAZ | DB Size | AllocatedStorage | BackupRetentionPeriod | Status | StorageEncrypted | PubliclyAccessible | +-----------------------------------------------------------+--------+---------------+---------+-------------+------------------+-----------------------+-----------+------------------+--------------------+ | rrgl3r5qn68j1.cqploip3wk2o.eu-central-1.rds.amazonaws.com | mysql | 5.7.17 | False | db.t2.micro | 20 | 7 | available | False | False | +-----------------------------------------------------------+--------+---------------+---------+-------------+------------------+-----------------------+-----------+------------------+--------------------+ |
Show snapshot details
Obtain a Snapshot Identifier from Resource Listing
Provide the Snapshot Identifier to the r3 db show command using the categorizing argument --snapshot-id
Snapshot details example
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
~$ r3 db show --snapshot-id rds:rr1repqcrd9r9p0-2017-11-20-03-37 # Response Project: service Company: root360 Environment: prod +--------------------------------------+--------------------+--------+------------------+------------------+---------------------+-----------+ | SnapshotIdentifier | DataBaseIdentifier | Engine | AllocatedStorage | StorageEncrypted | SnapshotCreateTime | Status | +--------------------------------------+--------------------+--------+------------------+------------------+---------------------+-----------+ | rds:rr1repqcrd9r9p0-2017-11-20-03-37 | rr1repqcrd9r9p0 | mysql | 20 | False | 2017-11-20_03:37:23 | available | +--------------------------------------+--------------------+--------+------------------+------------------+---------------------+-----------+ |
Related article
| Filter by label (Content by label) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...
|
| Page Properties | ||
|---|---|---|
| ||
|