Connect to Google Cloud SQL via VPC?

3
votes

I'm having two Projects in GCP with Cloud SQL & GKE

Project A
  -> Cloud SQL
Project B
  -> GKE Cluster

Now I want to access Cloud SQL from GKE Cluster for which I have two options.

 1. IPv4 address to connect
 2. Clous SQL Proxy as sidecar

But the problem is both of them connects via Public IP. And I'm worried about latency so I was thinking can we access via VPC ? or some kind of internal network ? so the read/write will be more faster.

2
google-cloud-platformvpcgoogle-kubernetes-engine
There's probably only two hops between your gke pod and Google Cloud SQL if they are both in the same availability zone. E.g. us-east-1b I tested this assumption with mtr and could confirm that. Ended up manually whitelisting the k8s nodes' public IPs to connect to the DB. Using the proxy gets slow and start failing under "heavy" load. I hope this helps - Humber

2 Answers

3
votes

Cloud SQL now supports private connections: https://cloud.google.com/sql/docs/mysql/private-ip

1
votes

Unfortunately not, the Cloud SQL is not accessed via internal, only through external IP or the Cloud SQL proxy. For GKE, using Cloud SQL Proxy as a sidecar container.