RDS PostgreSQL provides multiple disaster recovery solutions to ensure business continuity and high availability.
Comparison of disaster recovery solutions
RTO (Recovery Time Objective) refers to the time between when a failure occurs and when the system is restored to an available state.
RPO (Recovery Point Objective) refers to the maximum acceptable data loss duration during a disaster or system failure.
Solution | RTO | RPO | Price | Advantages | Disadvantages | Scenarios |
Global Distributed Cache (GAD) | Typically 10 to 30 seconds | Within 5 minutes, typically 30 seconds to 1 minute | Medium |
| Both source and disaster recovery instances must be RDS PostgreSQL with consistent major versions. | Suitable for cross-region disaster recovery between RDS PostgreSQL instances and cross-region read-only scenarios. |
Typically 10 to 30 seconds | Within 5 minutes, typically 30 seconds to 1 minute | Slightly high |
| Users need to ensure network connectivity themselves and bear the corresponding network costs. | Suitable for scenarios where self-built local instances or instances hosted by other cloud service providers use RDS PostgreSQL as disaster recovery instances. | |
Typically hours | Within 5 minutes, typically 30 seconds to 1 minute | Low |
|
| Suitable for scenarios where the source database is RDS PostgreSQL and cross-region disaster recovery does not have high requirements for recovery time. | |
Data synchronization (DTS) | Typically 10 to 30 seconds | Within 5 minutes, typically 30 seconds to 1 minute | High |
| Data synchronization is at the database level. When the number of instance databases is large, the cost is higher. | Suitable for non-full database disaster recovery or multi-active scenarios. |