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. |
HTML Comment | ||
---|---|---|
| ||
How to get an overview about your databases and backups? |
HTML Comment | ||
---|---|---|
| ||
→ Bild auf englische Seite verlinken, Bild= 30px |
Excerpt | ||
---|---|---|
| ||
How to get an overview about your databases and backups? |
...
Table of contents
Table of Contents | ||
---|---|---|
|
General usage instructions
...
Step-by-step guide
Show help context
...
Show help example
Code Block | |||
---|---|---|---|
| |||
~$ 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. |
Info |
---|
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 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
Code Block | |||
---|---|---|---|
| |||
~$ 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
Code Block | |||
---|---|---|---|
| |||
~$ 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 | +--------------------+--------+-----------+----------------------------------------------------------------+---------------------+ |
Related Articles
Filter by label (Content by label) | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
|
Page Properties | ||
---|---|---|
| ||
|