I have two setups here, one with a single cockraochdb and another with replication in different geo locations. A simple select query like “select * from abc” (Table abc has no foreign keys) that returns only 5 rows is 5 times slower on the replication setup than the stand-alone setup. Is this expected? Does the select query go to all servers? What if one of the servers is not responding? Please help. This is urgent.
I encourage you to give this page a read: Topology Patterns | CockroachDB Docs
Global deployments take more thinking than just deploying across multiple regions.