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. |
...
If you like to manually create a backup of the database (called snapshot).
Info | |
---|---|
title | Database Server SnapshotIn contrast to other providers, when initiating a database backup of AWS RDS Database Servers, no single logical database is secured. Instead a backup of the whole server is created, which then includes all logical databases on the system. |
Table of contents
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
Note | |
---|---|
title | Snapshot Creation ProcessWith the following commands you are initiating the creation of a backup (snapshot). This process can take several minutes, depending on the overall size of data. This will have minimal influence to the performance of your system! However, the Database Server will be in a state not allowing other operation e.g. it's immediate destruction or another backup. You can obtain details on this by looking for the details of the snapshot. |
Show help context
...
Show help example
Code Block | |||
---|---|---|---|
| |||
~$ r3 db snapshot -h # Response Initiate Snapshot Creation for a Database Server optional arguments: -h, --help show this help message and exit --loglevel {INFO,ERROR} Define Loglevel for Execution (default: INFO) db_id DataBaseIdentifier of Database Server to create a Snapshot of. |
How to create a snapshot
...
Obtain the identifier of the database e.g. by listing the available databases using the
r3 db list --dbs
commandProvide the identifier to the command line
r3 db snapshot
as shown in the example below.(Optional) Call the listing command again (
r3 db list
) and you can see the Identifier of the newly created snapshot and its current status.
...
...
Snapshot creation example
Code Block | |||
---|---|---|---|
| |||
~$ r3 db snapshot rrgl3r5qn68j1 # Response Company: root360 Project: service Environment: prod Started creation of new Snapshot: manual-rrgl3r5qn68j1-2017-11-21-12-50 This process can take up to 15 Minutes to finish! ~$ r3 db list Environment: prod Company: root360 Project: service +---------------------------------------+--------------------+--------+-----------+----------------------------+ | SnapshotIdentifier | DataBaseIdentifier | Engine | Status | CreationTime | +---------------------------------------+--------------------+--------+-----------+----------------------------+ | manual-rrgl3r5qn68j1-2017-11-21-12-50 | rrgl3r5qn68j1 | mysql | creating | 2017-11-21 12:50:25.246740 | | rds:rrgl3r5qn68j1-2017-11-14-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-14_00:19:42 | | rds:rrgl3r5qn68j1-2017-11-15-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-15_00:19:48 | | rds:rrgl3r5qn68j1-2017-11-16-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-16_00:19:24 | | rds:rrgl3r5qn68j1-2017-11-17-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-17_00:19:29 | | rds:rrgl3r5qn68j1-2017-11-18-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-18_00:19:49 | | rds:rrgl3r5qn68j1-2017-11-19-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-19_00:19:54 | | rds:rrgl3r5qn68j1-2017-11-20-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-20_00:19:50 | | rds:rrgl3r5qn68j1-2017-11-21-00-19 | rrgl3r5qn68j1 | mysql | available | 2017-11-21_00:19:28 | +---------------------------------------+--------------------+--------+-----------+----------------------------+ |
Related Articles
Filter by label (Content by label) | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
|
Page Properties | ||
---|---|---|
| ||
|