High availability
While read-only replicas offer a great way to increase read capacity, they do not offer any form of high availability. If either the master's zone or the replica's zone goes down, no failover will occur and the replica will be unavailable. In order to increase availability, a failover replica should be created instead.
All three types of Cloud SQL instances offer some manner of high availability in the form of failover. For first generation MySQL instances, high availability is enabled by default. All data is stored using multi-zone storage. In the event of a zonal outage, failover to another zone is automatically performed. Second generation MySQL failover and PostgreSQL failover are not enabled by default, but may be configured ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access