An RDS for PostgreSQL database has failed.
The business accepts at most five minutes of data loss and needs to resume service quickly after recovery.
Which restore method is most appropriate?
Use point-in-time recovery from the RDS automated backups to create a database instance at a selected time.
Detailed explanation
A CDN cache is not a database backup or restore mechanism.
A CDN cache is not a database backup or restore mechanism.
The restore point is too old and is unlikely to meet the allowed RPO.
The restore point is too old and is unlikely to meet the allowed RPO.
RDS can use automated backup logs to create a new database instance at a selected time.
RDS can use automated backup logs to create a new database instance at a selected time.
Events report state changes but are not a data source for restoring a database.
Events report state changes but are not a data source for restoring a database.
Check official documentation
Compare the following points with the official documentation.
Amazon RDS point-in-time restore and automated backupsの公式説明を確認する。
What to confirm
PITRと手動スナップショットをRPO・RTOの観点で比較できる。
Key points
- Point-in-time recovery
- RPO
- RTO
Notes
- Environment: AWS公式SOA-C03試験ガイドとAWS公式ドキュメントの確認
- Confirm current AWS service behavior in the official documentation.
Foundation review
Restore precision
Automated logs provide a finer restore point than an old manual snapshot.
Recovery target
RPO and RTO together determine whether a restore method meets the business requirement.