I have a VPC running on AWS which was created using kops, and the databases are running on mongo-atlas using GCP as a cloud provider.
The mongo database servers are open to the world, what I'm trying to do is find a way to set up one IP through with my VPC can talk to database or get a range of IPs or if any other solution possible?
Here is what I have already tried:
- VPC peering:- not possible because the database is running on GCP
- add all the public ip of the current running nodes to mongo atls: cant do that because I'm using autoscaling
- using elastic IPs, because I'm using autoscaling