We recently added snapshot in our strategy to ensure data recovery as much as we can in case our database falls into pieces.
AWS flow wants us to deploy a new DB instance from a snapshot directly, hence changing the DB URI.
Let’s say the DB fails at 3:30pm. Then we spin a new instance from a snapshot created at 3pm. How can I recover those 30 minutes of data ?
Do you have any recommandation on how to handle such data failure ?
We have set a snapshot creation every hour with a TTL of 35 days.