I have deployed 3 cockroach db clusters in Europe, Asia and USA region. Following this documentation. https://www.cockroachlabs.com/docs/stable/orchestrate-cockroachdb-with-kubernetes-multi-cluster.html
Now my applications also deployed on same 3 reigons. So i have expose cockroachdb-public service to the
load balancer from
cluster ip in each cluster. So i have 3 load balancer ip and using that ip i am accessing databases.
Now my issue is i am not getting same latency from all region. Some times from Asia region i got 50 to 60ms latency and the same time from Europe it was 1 to 2 seconds. I am checking that from my apps.
Suggest me the best option to reduce the latency and performance.