Database / ScyllaDB Interview questions
How can you optimize a multi-datacenter ScyllaDB deployment for latency?
- Use LOCAL_QUORUM (or ONE/LOCAL_ONE) for regular application traffic so requests don't pay cross-datacenter round trips.
- Set NetworkTopologyStrategy replication per-datacenter so each region has enough local replicas to satisfy local consistency without depending on a remote datacenter.
- Route application traffic to the nearest datacenter at the load balancer or driver level, rather than letting requests land anywhere and potentially hit a remote coordinator.
- Reserve cross-datacenter QUORUM reads/writes for the few operations that truly need global strong consistency, not as a default.
- Monitor inter-DC replication lag - if remote datacenters fall behind, LOCAL_QUORUM reads stay fast but the data available there becomes more stale.
The general principle mirrors other distributed databases: cross-region network latency is a physical constraint no amount of tuning removes, so the optimization goal is minimizing how often a request actually needs to cross that boundary rather than trying to make the crossing itself faster.
More Related questions...