The question:
Yugabytedb is a distributed rdbms. It uses data redundancy. How does it keep a good performance while having to keep multiple copies up to date?
The Solutions:
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
Method 1
Reads go to the raft leader and writes as well but wait for the quorum. So it depends on the topology. A Replication Factor RF=3 on one AWS region, for example, doesn’t suffer as latency between AZs is low. For cross-region distribution, this is addressed with placement preferences. Like having all leaders near the users, and one nearby region will answer the quorum.
Those preferences can be mapped to business info (like customer’s country) through PostgreSQL partitioning and tablespaces
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0