Exam Professional Cloud Database Engineer topic 1 question 60 discussion

A. Cloud SQL is a regional service so the primary and standby instances must be in the same region. A recommended practice would have them in different zones. A read replica could be in a different region, but that option isn’t offered probably because it would be too far away from the user base. Having it in a different zone from the primary and standby instances is therefore the best and only answer.

A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region. This option follows Google-recommended practices for high availability by distributing the instances across multiple zones within the same region. This setup ensures that: The primary instance and standby instance are in different zones, providing resilience against zonal failures. The read replica is also in a different zone, allowing for load balancing of read operations and further protection against zone-specific outages.

The correct answer is ==> B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

HA standby instance can't be located in different region, and Google recommends to use different zones for all three, so answer is A https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview

The HA configuration provides data redundancy. A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.

A: Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.