RDS pre-upgrade double snapshot backup sequence
I noticed that RDS creates two snapshots before upgrading an instance:
"rds:{InstanceID}-{current-datetime}"
Shuts down instance...
"rds:preupgrade-{InstanceID}-{old-version}-to-{new-version}-{autoid}"
I was curious to know why.
- Newest
- Most votes
- Most comments
Hi,
I've came across the same situation where my RDS instance off-line patches has been applied. Then i came across this blog https://jayendrapatil.com/aws-rds-db-maintenance-upgrades/ to understand the reasons behind it.
DB instance will go offline while performing any OS level upgrades, engine version major upgrades.
In this case two snapshots serve as backup measures to minimize data loss and ensure that you have recovery options in case of any problems during the upgrade process. The first snapshot captures the state just before the upgrade, while the second snapshot captures the state after the instance has been shut down and is ready for the upgrade. This dual-snapshot approach is a best practice in ensuring the resilience and reliability of your database during upgrades.
Relevant content
- asked 3 months ago
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 6 months ago
That blog post doesn't mention two snapshots being taken before upgrade - only one:
"RDS takes two DB snapshots during the upgrade process. First DB snapshot is of the DB instance before any upgrade changes have been made. If the upgrade fails, it can be restored from the snapshot to create a DB instance running the old version. Second DB snapshot is taken when the upgrade completes. After the upgrade is complete, database engine can’t be reverted to the previous version. For returning to the previous version, restore the first DB snapshot taken to create a new DB instance."