How to Restore Data from an Amazon RDS Database Snapshot
A guide to restoring data from an Amazon RDS Database Snapshot.
In this tutorial, I’m going to show you how you can restore data from the AWS RDS Database snapshot.
Let’s Get Started
You can create a DB instance by restoring from an automatic or a manual snapshot. You can’t restore from a DB snapshot to an existing DB instance because a new DB instance is created when you restore a DN snapshot.
When you restore a DB instance, the default security group is associated with the restored instance by default, and the option group and the parameter group associated with the DB snapshot are associated with the restored DB instance after it is created.
You can also change these settings after the instance is restored.
STEPS
- Log in to your account and open the AWS RDS console in the same AWS Region as the DB snapshot.
2. Choose a snapshot from the navigation pane, and choose the snapshot you want to restore.
3. From the actions drop-down menu, choose to Restore snapshot
4. Specify the DB instance identifier, this will create the instance endpoints that you will connect to, and select the VPC, Subnet, and security groups where you want to restore the instance to.
- You can also change the database port if required.
- Specify the DB instance class if required.
- Change the storage type for your instance if required.
However, note that this will affect the time it takes for the instance to be restored.
5. Select if you want a multi-AZ deployment. Multi-AZ deployment provides high availability to your instance by launching a second instance as a fail-over if the primary instance becomes unavailable.
6. Select the availability zone preference that you want for your restored instance.
7. Choose the Database authentication option
- You can choose the IAM option if you authenticate using a database password and user credentials through AWS identity and access management users and roles. I will keep a password only :)
8. Choose the parameter group and options group that you would want to use with your RDS instance. By default, the restored instance will use the same parameter and options group that was attached with the instance that’s been restored.
9. You can also select the log files to publish the logs to the Amazon CloudWatch log for long-term retention. In this case, I will enable only error logs.
10. Select Maintenance if you want to enable auto minor version upgrades for your restored instance. Enabling auto minor version upgrade will automatically upgrade to a new minor version as they are released. The automatic upgrades occur during the maintenance window for your database.
When you are done, click on Restore DB Instance.
After the instance is restored and available, you can modify the parameter group and options group.
- Select the instance and choose modify on the right of the console screen.
- In the menu, you can choose the required security groups with the inbound and outbound rules for your instance.
- Choose the parameter or option group that you require.
- Choose Continue, and select if you want to apply these changes immediately or apply in the next maintenance window.
If you select immediately, then the instance will be modified immediately, otherwise, the changes will be applied during the next maintenance window.
Make sure you confirm if the changes you want to apply are correct and then choose Modify DB Instance.
Go back to your dashboard. You will see that the instance is now restored and available for access.
Inspiration and Motivation: AWS Web Services
Gracias
Enjoyed the read? Leave some ‘claps’ below so others can find this post. 🙂
Check out my other posts :)
https://thecraftman.medium.com/
More content at plainenglish.io
