(Archived) How to obtain detailed information about a database or database backup
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
General usage instructions
The general usage instructions for the cloud managment tool suite r3 can be found here.
Step-by-step guide
Show help context
Usage of r3 db show
~$ 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.
Environment Support
You 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
~$ 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
~$ 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
root360 Knowledge Base - This portal is hosted by Atlassian (atlassian.com | Privacy Policy)