Article
Create a MySQL RDS Backup and Restore

April 01, 2020

INTRODUCTION

This article describes how to create an RDS MySQL backup and restore it from the backup using the Amazon Web Services console.

OBJECTIVE

Create a MySQL RDS backup and restore on Amazon Web Services (AWS).

PRE-REQUISITES

  • You will need to get an account at AWS
  • Basic knowledge on AWS services

BEFORE WE BEGIN

Before starting, consider the following points:

  • We will use the default VPC, so we don’t need to setup one
  • An RDS instance must already be created (To create a new RDS instance, please refer to this article)
  • Following the best practices, the RDS instance must not publicly accessible but for the purposes of this article it will be created public

STEPS TO CREATE A MYSQL RDS BACKUP

Creation of Database snapshot

Go to AWS console and navigate to RDS service, from the left panel select the “Databases” option. Select the database that you want to backup and click on “Actions” then on “Take snapshot” (Fig. 1).

01_1

In the next screen, just type a name for the snapshot and finally click on “Take Snapshot” (Fig. 2)

02_0

Next you will be redirected to the Snapshots dashboard, it will show you the information of your snapshot and the status will be “creating” (fig. 3).

After a few minutes, your snapshot will be created (the time it takes to create the snapshot depends on the size of your database).

Note: if your database is configured to Multi-AZ you will not suffer any I/O suspension since the backup is taken on the standby, otherwise you may suffer this issue.

03_0

STEPS TO RESTORE A MYSQL RDS INSTANCE FROM A SNAPSHOT

Restore from an existing snapshot

In RDS service click on Snapshots from the left menu.

Here will be listed all your snapshots that you have taken (fig. 3), select the one that you want to restore and click on “Actions” and then on “Restore Snapshot” (fig. 4).

04_0

You will be redirected to the Restore DB Instance screen (it is really similar from where you created a new instance) and you have to input the characteristics and settings for the instance that will be created from the snapshot.

05_006_007_008_0

 

09_0

When you are satisfied with the specifications click on “Restore DB Instance”.

After this, you will be redirected to Databases section and it will show that the new instance is being created, after a few minutes the instance will be up and running.

 

Conclusion

In this article we showed how to create a snapshot of an RDS instance and to restore a database from a snapshot in AWS using its console. Applying these steps, you can have your own backups and restores in an easy, fast and secure manner when you are using AWS Relational Database Service.

 

 

INSIGHTS

Recommended

Article
Common Staffing Challenges and How to Overcome Them
Article
Software Development Outsourcing Models
Article
Benefits of Outsourcing to Mexico
Whitepaper
Nearshore Software Solutions as an Outsourcing Strategy

How can we help you?

IO Connect Services is here to help you by offering cost-effective, high quality technology solutions.