AWS RDS KMS Key Deletion

  


  1. Run script to delete the KMS Key
  2. Once keys are deleted, AWS doesn't delete the key permanently, it just marks the keys for deletion only, makes the keys disabled and delete after 7 days.
  3. AWS RDS using the key, won't be accessible. And we will see below error instead [ inaccessible-encryption-credentials ]. instead
  4. Recovery, in order to recover the RDS database back, followed below steps
    1. enabled the KMS Key, such that its not longer scheduled for deletion
    2. Restore the RDS database snapshot
    3. Create a new RDS database instance, you can't use the exact name, must name it something different , lets call is DB-2
    4. Review all the details are correct such that Virtual Private Cloud, Security Group etc
    5. Delete the old RDS database ( DB-1 ) 
    6. Rename database DB-2 and DB-1
    7. Run all the tests and connectivity with database

Comments

Post a Comment

Popular posts from this blog

What I learned this week - 19th June 2023

 ThreatComposer - awslabs.github.io/threat-composer/ AWS State Machine Versioning  Google - Cloud Economics - Cloud Econ 101 ChatGPT Springboot interface - chatgpt-spring-boot-starter 0.3.0 released Future of Observability - AI for Observability AWS DynamoDB Streams Airbnb improves Web performance with HTTP streaming DB race condition - https://vladmihalcea.com/race-condition/ Webhook
Read more

What I learned this week - 22nd May 2023

CockroachDB   CockroachDB is a distributed SQL database that is designed to be scalable, reliable, and easy to use. It is a good choice for applications that need to be able to handle a large amount of data and traffic, and that need to be highly available. Feature CockroachDB MySQL PostgreSQL Scalability Horizontal Vertical Vertical Availability High Medium Medium Consistency Strong Eventual Eventual SQL compatibility Yes Yes Yes Geo-replication Yes No No FerretDB FerretDB is an open-source, distributed, and scalable document database that is compatible with MongoDB. It is built on top of PostgreSQL and uses its query planner and execution engine. This makes it a good choice for developers who are familiar with MongoDB and want to use a more scalable and reliable database. Feature FerretDB MongoDB DocumentDB Open source Yes No No Built on top of PostgreSQL MongoDB .NET Scalability High Medium Medium Reliability High Medium Medium Complexity High Medium Medium System Design Concept...
Read more