Restoring an AWS Aurora cluster from a snapshot using the same cluster identifier using CDK

Dominique M 0
Viewed 30

Scenario:

  • An AWS Aurora (Postgres) cluster is currently running, but something is wrong with it.
  • To solve this issue, I want to restore a cluster snapshot created some days earlier and reset to that point in time.
  • I use CDK for my infrastructure and restore the cluster using the DatabaseClusterFromSnapshot class.

Problem: the old cluster and new cluster must carry the exact same cluster identifier. Because AWS deletes the old cluster only after the new cluster is created, this results in a naming conflict.

Is there any feasible way to reach my goal of having the new cluster carrying the exact same name? On our production environment, there is deletion protection so I cannot create a custom resource to delete the cluster before the new one is created.

database-restore snapshot amazon-rds aws-cdk amazon-web-services
1 Answers
  1. Manually rename my_cluster to my_cluster_old. Follow this AWS guide (see caveats about read replicas). The commands for clusters may be somewhat different (e.g., modify-db-cluster).
  2. Restore the snapshot to my_cluster.
  3. Delete my_cluster_old.
t_krill0
Related