(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

Knowledge Base to find more documents.

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 |
+--------------------------------------+--------------------+--------+------------------+------------------+---------------------+-----------+

Table of contents