Question

You run a self-managed PostgreSQL database on a single Compute Engine VM in the us-central1-a zone. The business requires that if the zone fails, you can quickly restart the database on a VM in another zone within the same region without losing committed data or restoring from a backup. Which storage configuration best meets this requirement?

Accepted Answer

Attach a regional persistent disk to the VM so the disk is synchronously replicated across two zones in the region

Answer

Use a zonal SSD persistent disk and schedule hourly snapshots to Cloud Storage

Answer

Attach a local SSD to the VM for the database data files

Answer

Store the database data files in a Cloud Storage bucket mounted with Cloud Storage FUSE