I have set up a cockroach DB multi-region database on GCP Kubernetes. One is in Asia and the other is in the US region. Now I want to expose the database to the public because my front end apps are running on AWS. My question is can I expose the database to the global load balancer of GCP?
If I can’t expose it to the GCP global load balancer and use regional TCP load balancer then How my app will forward traffic to the nearest database location? Because I have to expose 2 TCP load balancer in each region.
Kindly share the best practice to access a multi-region database publically using a single IP address or any other way to access the database.