Cloud SQL for PostgreSQL adds high availability and replication

Cloud SQL for PostgreSQL users, we heard you loud and clear, and added support for high availability (HA) and read replicas, helping you ensure your database workloads are fault tolerant.

The beta release of high availability provides isolation from failures, and read replicas provide additional read performance — requirements for demanding workloads.

“As a global retail company, who uses digital innovation and data collaboration to enrich consumers’ experiences with retailers and venues, we have very high availability requirements and we trust Cloud SQL for PostgreSQL with our data.”

— Peter McInerney, Senior Director of Technical Operations at Westfield Retail Solutions

“We love Postgres and rely upon it for many production workloads. While our Compute Engine VMs running Postgres have never gone down, the added peace of mind provided by HA and read replicas combined with reduction in operations makes the decision to move to the new Cloud SQL for PostgreSQL a simple one.”

— Jason Vertrees, CTO at RealMassive

Additional enhancements include database instance cloning and higher performance instances with up to 64 vCPU cores and 416GB of RAM. Cloud SQL for PostgreSQL is also now part of the Google Cloud Business Associates Agreement (BAA) for HIPAA covered customers. And in case you missed it, we added support for 19 extensions this summer.

Understanding the high availability configuration

The high availability configuration on Cloud SQL for PostgreSQL is backed by Google’s new Regional Disks, which synchronously replicate data at the block-level between two zones in a region. Cloud SQL continuously health-checks HA instances and automatically fails over if an instance is not healthy. The combination of synchronous disk replication and automatic failover provides isolation from many types of infrastructure, hardware and software failures.

Reference: https://cloudplatform.googleblog.com

Leave a Reply

Your email address will not be published. Required fields are marked *