(Archived) How to get an overview about your databases and backups

Owned by Former user (Deleted)
Last updated: Jan 30, 2021 by Steffen Drya
3 min read

You have tried to access an archived page. Please go to the new

Knowledge Base 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

Show help example
~$ r3 db list -h # Response List Database Servers and Snapshots for this Environment. optional arguments: -h, --help show this help message and exit --loglevel {INFO,ERROR} Define Loglevel for Execution (default: INFO) --all List all Snapshots for all Database Servers. --dbs Only list Database Servers. --snapshots Only list 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 a list of snapshots sorted by respective database servers of the selected environment

  • This will show you the unique identifiers of the backup and the database the backup was created from (required for further operations using the tool suite),

  • the engine,

  • the current state of the backup, e.g. available or creating and

  • the creation time of the backups

Show databases and snapshot example
~$ r3 db list [--all, --snapshots] # Response Environment: prod Project: backend Company: root360 +--------------------------------------------+--------------------+--------+-----------+---------------------+ | SnapshotIdentifier | DataBaseIdentifier | Engine | Status | CreationTime | +--------------------------------------------+--------------------+--------+-----------+---------------------+ | manual-br1oaelplxcuew9-rr-2017-11-19-14-05 | br1oaelplxcuew9-rr | mysql | available | 2017-11-19_14:05:33 | | manual-br1oaelplxcuew9-rr-2017-11-21-13-05 | br1oaelplxcuew9-rr | mysql | available | 2017-11-21_13:05:31 | | rds:br1oaelplxcuew9-2017-11-14-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-14_00:03:27 | | rds:br1oaelplxcuew9-2017-11-15-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-15_00:03:54 | | rds:br1oaelplxcuew9-2017-11-16-00-05 | br1oaelplxcuew9 | mysql | available | 2017-11-16_00:06:11 | | rds:br1oaelplxcuew9-2017-11-17-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-17_00:03:49 | | rds:br1oaelplxcuew9-2017-11-18-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-18_00:03:55 | | rds:br1oaelplxcuew9-2017-11-19-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-19_00:04:03 | | rds:br1oaelplxcuew9-2017-11-20-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-20_00:03:52 | | rds:br1oaelplxcuew9-2017-11-21-00-03 | br1oaelplxcuew9 | mysql | available | 2017-11-21_00:03:31 | +--------------------------------------------+--------------------+--------+-----------+---------------------+

Show a list database servers of the selected environment

  • This will show you the unique identifiers needed for further operations using the tool suite,

  • the actual engine used,

  • the status of the database server

  • the Endpoint that is used to connect to the database and

  • the date and time of creation

Show databases example
~$ r3 db list --dbs # Response Environment: prod Project: backend Company: root360 +--------------------+--------+-----------+----------------------------------------------------------------+---------------------+ | DataBaseIdentifier | Engine | Status | Endpoint | CreationTime | +--------------------+--------+-----------+----------------------------------------------------------------+---------------------+ | br1oaelplxcuew9 | mysql | available | br1oaelplxcuew9.cbjm32dvn278.eu-central-1.rds.amazonaws.com | 2016-08-09_13:40:11 | | br1oaelplxcuew9-rr | mysql | available | br1oaelplxcuew9-rr.cbjm32dvn278.eu-central-1.rds.amazonaws.com | 2016-09-28_06:38:03 | +--------------------+--------+-----------+----------------------------------------------------------------+---------------------+



root360 Knowledge Base - This portal is hosted by Atlassian (atlassian.com | Privacy Policy)