Restoring RDS Snapshots Too Long

Question

As part of our blue green deployment strategy, we reduce the RDS prod instance and then restore this snapshot to a new instance by applying db migrations after it and associating the new Green application with it.

Our RDS instance has a space of 100 GB, but our database currently only uses 10 MB.

Taking a snapshot takes approximately <2 minutes

Snapshot recovery takes 25 minutes!

25 minutes to recover is too long, given that users are forced to remain in read-only mode for this entire period and that our database is less than 10 MB in size.

I am wondering if this recovery time is the usual time for Amazon RDS or if we are doing something wrong.

• Amazon RDS Postgres.
• Multi AZ: Yes
• Instance Class: Medium
• General Purpose (SSD)
• IOPS: Disabled.

Answer 1

After some experiments, we were able to reduce the recovery time from 25 minutes to 5 minutes. This was due to the fact that RDS first tries to restore the snapshot. (In our case, it took 5 minutes). And then he applied the Multi Az change to the new instance. (it took about 20 minutes)

, MULTI AZ, = "", , AWS , , MULTI AZ. , "" ""

, , , , .

, , PROD. , , .