Page Comparison

...

Info

title	Database Server Snapshot

In 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.

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 Process

With 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

Code Block

language	text
title	Show help example
linenumbers	true
collapse	true

~$ 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 --dbscommand
Provide 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.

Code Block

language	text
title	Snapshot creation example
linenumbers	true
collapse	true

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

Versions Compared

Old Version 20

New Version 21

Key

Table of contents

General usage instructions

Step-by-step guide

Show help context

How to create a snapshot

Related Articles