I have 2 separate GKE VPC-native clusters (gke1, gke2) and a Compute Engine instance (ce1), each in a separate VPC network. I would like to set up a Cloud SQL (Postgres) that can be connected from both GKE clusters (gke1, gke2) and the Compute Engine instance (ce1).
Is this possible without using the Public IP setup for Cloud SQL, perhaps using VPC Network Peering or another solution, if so how to setup such configuration?
I have done some research and I'm well aware that the documentation says the following
GKE cluster must be VPC-native and in the same VPC network as the Cloud SQL instance
But I wonder whether it could be possible using VPC Network Peering or another approach
I have found some other related questions here on SO, some are not specific for GKE and some are from a few years back so I'm not sure whether it's still valid.
Related questions I have found: