HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What does "Latest Restore Time" says in AWS RDS(Mysql) instances page

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
latestwhatinstancestimemysqlsaysdoesawspagerds

Problem

I have two RDS MySQL instances and when I look at the instances page, I have seen a field named "Latest Restore Time" and the value for it is some time stamp in IST time zone.

I would like to know what it actually mean. Being the individual server:

  • What is the need for this to be Restored?



  • Where it gets restored?

Solution

Given the RDS Console tooltip, the Latest Restore Time defines The latest time to which a database can be restored with point-in-time restore. and not the last time the database was restored.

The database can be restored from Amazon RDS Automated Backup tool that can be configured in the Amazon RDS Modify DB Instance page. The default window backup is 7 days, every 30 minutes.

Context

StackExchange Database Administrators Q#94582, answer score: 7

Revisions (0)

No revisions yet.