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!
1. Signin to AWS Management Console
2. Create RDS MySQL instance
3. Create a snapshot
4. Validate the creation of RDS snapshot
- AWS user account with admin access, not a root account.
- SignIn to the AWS Management Console using username and password in the AWS Region as US East (N. Virginia) us-east-1
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
Wait for 5-6 minutes to see the database created.
On the RDS Console, in the left side panel click Snapshots, Take snapshot
Choose the DB Instance you created
Enter the snapshot name -
Wait for 5-6 minutes to see the snapshot created.
- Check the snapshot details by clicking on the snapshot and viewing the details of your DB Instance
From the Amazon RDS Console, delete RDS database snapshot -
delete RDS database -
- We have successfully created a RDS MySQL instance, created and validated a RDS Database Snapshot.