How can I time restoring from a DB snapshot

0

For our disaster recovery I would like to be able to show an audit log of how long it takes to recover our main (AWS MySQL RDS) database.. is there a good way of doing that? Thanks!

asked 3 years ago473 views
2 Answers
0

Hi petew2452,

Thank you for posting your question here.

You want to show an audit log of how long it takes to recover or restore an AWS MySQL RDS database.

This can be accomplished using RDS Events, basically, you capture in RDS events when it start and completes. The instance's RDS event will record something as follows: https://ibb.co/NW85YZS

This will be the time to restore the entire database, this is available for 24 hours in the console and then another 14 days in through the CLI describe-events.

The logs should also have some info, but this will differ from engine to engine and they also get rotated out, see https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html. The restore actions will be logged in CloudTrail, although they will not have elapsed time.

For more information on RDS Events, see https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/working-with-events.html.

Hopefully this helps. Should you have any further queries or concern, please feel free to reach out.
Thanks,
Ayabulela

Edited by: Ayaar on May 24, 2021 4:37 AM

ayaar
answered 3 years ago
0

Hi Ayaar

Thanks for this.. I didn't spot that.

As a feature request, what these logs don't do is log an event "Database Restore to Point in Time Started" - that might be a useful thing to log. The first event I get was about 10 minutes after starting the process (confusingly, titled "DB instance shutdown").

Kind regards,
Peter

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions