Taking automatic backup, RDS snapshots, and restore and read replicas
In this section, we will see how RDS Automatic Backup and Manual Snapshots work. These features come with Amazon RDS.
Let's consider a database that is scheduled to take a backup at 5 A.M. every day. If the application fails at 11 A.M., then it is possible to restart the application from the backup taken at 11 A.M. with the loss of 6 hours' worth of data. This is called 6 hours RPO (Recovery Point Objective). So, RPO is defined as the time between the most recent backup and the incident and this defines the amount of data loss. If you want to reduce this, then you have to schedule more incremental backups, which increases the cost and backup frequency. If your business demands a lower RPO value, then the business must spend more on meeting the technical solutions.
Now, according to our example, an engineer was assigned this task to bring the system online as soon as the disaster occurred. The engineer...