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.
- Más nuevo
- Más votos
- Más comentarios
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.
Contenido relevante
OFICIAL DE AWSActualizada hace un año- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 4 meses
- OFICIAL DE AWSActualizada hace 3 años
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."