How can you restore availability to a Cloud SQL for PostgreSQL instance with a primary in region 1 and a read replica in region 2 after a region 1 failure, while minimizing data loss and adhering to Google's best practices?

Exam-Like

Restore the Cloud SQL instance from the automatic backups in region 3.

0.0%

Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

8.3%

Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance._

75.0%

Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

16.7%

Google Professional Cloud Database Engineer

Get started today

Comments

How can you restore availability to a Cloud SQL for PostgreSQL instance with a primary in region 1 and a read replica in region 2 after a region 1 failure, while minimizing data loss and adhering to Google's best practices?