A Cloud Engineer needs to deploy a Cloud SQL for PostgreSQL instance that connects exclusively via private IP to a Virtual Private Cloud (VPC) network and supports regional High Availability (HA). Which TWO configuration actions must be performed to meet these requirements?
- Establish a Private Services Access connection by allocating an internal IP range and creating a VPC peering connection in the target VPC.Answer
- BAdd the IP range 0.0.0.0/0 to the instance Authorized Networks setting.
- Specify the flag --availability-type=REGIONAL during instance creation.Answer
- DSpecify the flag --preemptible during instance creation to provision standby failover capacity.
Answer
To deploy a Cloud SQL instance with private IP connectivity and High Availability, you must allocate an internal IP range to set up Private Services Access via VPC peering and specify the REGIONAL availability type during deployment.
Establishing a Private Services Access connection configures VPC peering and internal IP allocation for private connectivity. Specifying the REGIONAL availability type ensures a standby replica is provisioned in another zone for high availability failover.
Step-by-Step Solution
Key Concept
Deploying Cloud SQL with Private IP and High Availability