Data corruption can happen due to many reasons e.g. accidentially deletion/manipulation records from important tables. Also, hardware failure/outage may cause data loss. Hence, strong data recoverability strategy is required.
These settings require alignment with Service level agreemnts.
Configuring automated backup requires defining,
- Retention period
- Backup window(30 minutes) in UTC
- (Optional) Replicating region
When Automated Backup is configured, screenshot may look like this
Automated backups for Current region can be seen in this screen
Daily: Instance Level full backup during defined backup window
Every 5 minutes: Transaction log backup
When automated backups are turned on for your DB instance, Amazon RDS automatically performs a full daily snapshot of your data. The snapshot occurs during your preferred backup window. It also captures transaction logs to Amazon S3 every 5 minutes (as updates to your DB instance are made). Archiving the transaction logs is an important part of your DR process and PITR.
When you initiate a point-in-time recovery, transactional logs are applied to the most appropriate daily backup in order to restore your DB instance to the specific requested time.
AWS RDS allows recovery upto last 30 minutes from current timestamp, refer this screenshot
