RDS: Testing the restore of the entire database to the last recoverable time possible?

0

Hi,

I ran the DR test and I managed to restore a new RDS instance using the PITR on the (RDS) Automated backup, however when I inspected the data in the database I only found a very small subset of the data in the new DB instance. I would have thought it would replay the snapshot and apply all the WAL logs it has at its own disposal, but I might be mistaken.

What is the correct DR recovery procedure to recover the entire database to the latest possible time?

Cheers, Peter.

pbocan
質問済み 1ヶ月前112ビュー
2回答
0
profile pictureAWS
エキスパート
回答済み 1ヶ月前
profile picture
エキスパート
レビュー済み 1ヶ月前
0

Hello,

Please note, RDS automated backup takes snapshot everyday during backup window and it uploads transaction logs (wal logs) for DB instances to Amazon S3 every five minutes.

Furthermore, to see the latest restorable time for a DB instance, use the AWS CLI describe-db-instances command and look at the value returned in the LatestRestorableTime field for the DB instance [1]. Optionally, to see the earliest restorable time for each DB instance, choose Automated backups in the Amazon RDS console.

Generally, RPO would be 5 mins using RDS automated backups because transaction logs backup is taken every 5 mins to S3.

Reference

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html : Restoring a DB instance to a specified time

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquiries in repost/aws guide.

Thank you!

AWS
回答済み 1ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ