✏️ Explanatory Question
RPO (Recovery Point Objective) - how much data you can afford to lose, measured in time. RPO of 5 minutes means losing at most the last 5 minutes of writes.
RTO (Recovery Time Objective) - how long you can afford to be down during recovery.
RPO drives replication:
RTO drives standby strategy:
Both get expensive fast, so set them per dataset: RPO 0 for payment transactions, but RPO of a day is fine for derived analytics that can be recomputed. And always add that an untested backup is not a backup - restores must be rehearsed.