Wondering how to delete or terminate Amazon RDS resource? We can help you.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how our Support Techs do that.

How to delete or terminate Amazon RDS resource?

In order to stop all Amazon RDS-related charges for an account, perform the following in all AWS Regions:

• Delete all RDS DB instances.
• Delete Amazon Aurora clusters, if you have any.
• Then, delete all manual DB snapshots.

Today, let us see the steps followed by our Support Techs in order to perform these activities.

How to delete all RDS DB instances?

To delete a DB instance, you must follow below steps:

• Firstly, provide the name of the instance
• Enable or disable the option to take a final DB snapshot of the instance
• Finally, enable or disable the option to retain automated backups

If you delete a DB instance that has read replicas in the same AWS Region, each read replica is promoted to a standalone DB instance.

Deletion protection

You can only delete instances that don’t have deletion protection enabled.

When you create or modify a DB instance, you have the option to enable deletion protection so that users can’t delete the DB instance.

Deletion protection is disabled by default for you when you use AWS CLI and API commands.

To delete a DB instance

1.Firstly, sign in to the AWS Management Console and open the Amazon RDS console.
2.In the navigation pane, choose Databases, and then choose the DB instance that you want to delete.
3.For Actions, choose Delete.
4.To create a final DB snapshot for the DB instance, choose Create final snapshot?.
5.If you chose to create a final snapshot, enter the Final snapshot name.
6.To retain automated backups, choose Retain automated backups.
7.Then, enter delete me in the box.
8.Finally, choose Delete.

How to delete a DB instance from an Amazon Aurora DB Cluster?

In order to delete a DB instance, follow below steps:

1.Firstly, sign in to the AWS Management Console and open the Amazon RDS console.
2.In the navigation pane, choose Databases, and then choose the DB instance that you want to delete.
3.For Actions, choose Delete.
4.Then, enter delete me in the box.
5.Finally, choose Delete.

Deleting an empty Aurora cluster

If you use the AWS Management Console, Aurora automatically deletes your cluster when you delete the last DB instance in that cluster.

Thus, the procedures for deleting an empty cluster only apply when you use the AWS CLI or the RDS API.

You can keep a cluster with no DB instances to preserve your data without incurring CPU charges for the cluster.

You can quickly start using the cluster again by creating one or more new DB instances for the cluster.

Also, you can perform Aurora-specific administrative operations on the cluster while it doesn’t have any associated DB instances.

You just can’t access the data or perform any operations that require connecting to a DB instance.

To delete an empty Aurora DB cluster by using the AWS CLI, call the delete-db-cluster command.

To delete an empty Aurora DB cluster by using the Amazon RDS API, call the DeleteDBInstance operation.

How to delete all manual DB snapshots?

To delete a DB snapshot, follow the below steps:

1.Firstly, sign in to the AWS Management Console and open the Amazon RDS console.
2.In the navigation pane, choose Snapshots.
3.The Manual snapshots list appears.
4.Choose the DB snapshot that you want to delete.
5.For Actions, choose Delete Snapshot.
6.Finally, choose Delete on the confirmation page.

[Need help with the process? We’d be happy to assist]

Conclusion

In short, we saw how our Support Techs delete or terminate Amazon RDS resource.