DEV Community

Revathi Joshi for AWS Community Builders

Posted on

5

Create RDS Database Snapshots

In my previous article - Create a MySQL RDS Database Instance with Terraform and connect with MySQL Workbench, I have shown you how to create a MySQL RDS Database Instance with Terraform.

In this article, I am going to demonstrate on how you create a MySQL RDS Database Instance and RDS Database Snapshot.

Please visit my GitHub Repository for RDS projects on various topics being updated on constant basis.

Let’s get started!

Objectives:

1. Signin to AWS Management Console

2. Create RDS MySQL instance

3. Create a snapshot

4. Validate the creation of RDS snapshot

Pre-requisites:

  • AWS user account with admin access, not a root account.

Resources Used:

Steps for implementation to this project:

1. Signin to AWS Management Console

  • SignIn to the AWS Management Console using username and password in the AWS Region as US East (N. Virginia) us-east-1

2. Create RDS MySQL instance

  • On the Amazon RDS Console, Create database, Standard create, Engine type - MySQL, Templates - Free tier, Under Settings, DB instance identifier - myrdsinstance, Master username - admin, Master password - admin1234, Confirm master password - admin1234, DB instance class - db.t2.micro, Allocated storage - 20 GB, Storage autoscaling - uncheck Enable storage autoscaling, Monitoring - Uncheck Enable Enhanced monitoring, Under Additional Configuration, Backup - Uncheck Enable automated backups, Maintenance - Uncheck Enable auto minor version upgrade, Deletion protection - Uncheck Enable deletion protection, Take all defaults

  • Create database

  • Wait for 5-6 minutes to see the database created.

Image description

3. Create a snapshot

  • On the RDS Console, in the left side panel click Snapshots, Take snapshot

  • Choose the DB Instance you created myrdsinstance

  • Enter the snapshot name - myrdsinstancesnap

  • Take Snapshot

  • Wait for 5-6 minutes to see the snapshot created.

Image description

4. Validate the creation of RDS snapshot

  • Check the snapshot details by clicking on the snapshot and viewing the details of your DB Instance

Image description

Cleanup

  • From the Amazon RDS Console, delete RDS database snapshot - myrdsinstancesnap

  • delete RDS database - myrdsinstance

What we have done so far

  • We have successfully created a RDS MySQL instance, created and validated a RDS Database Snapshot.

Image of Datadog

The Essential Toolkit for Front-end Developers

Take a user-centric approach to front-end monitoring that evolves alongside increasingly complex frameworks and single-page applications.

Get The Kit

Top comments (0)

Best Practices for Running  Container WordPress on AWS (ECS, EFS, RDS, ELB) using CDK cover image

Best Practices for Running Container WordPress on AWS (ECS, EFS, RDS, ELB) using CDK

This post discusses the process of migrating a growing WordPress eShop business to AWS using AWS CDK for an easily scalable, high availability architecture. The detailed structure encompasses several pillars: Compute, Storage, Database, Cache, CDN, DNS, Security, and Backup.

Read full post