Posted On: Jun 4, 2020

Amazon Aurora with PostgreSQL Compatibility has added support for managing the recovery point objective (RPO) in an Aurora PostgreSQL Global Database configuration.

Global Database is a database configuration that allows you to create up to five secondary clusters, each in an AWS Region separate from the primary cluster’s Region. These clusters are maintained using storage-based replication, with low Recovery Point Objective (RPO) and low Recovery Time Objective (RTO). With managed RPO, you can ensure that the Global Database will automatically stay within your desired window of data recovery.

Managed RPO monitors the replication lag to ensure that at least one of the secondary clusters stays within the target RPO window. If all secondary clusters fall behind the target RPO, transactions will pause in the primary cluster until at least one of the secondary clusters catches up.

You can configure Managed RPO with the recent launch of Aurora PostgreSQL 11.7 and 10.12. For more information, see the documentation.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page.