Code RoomReplication lag read inconsistency
HardPrep Room Coding #2840

Replication lag read inconsistency

On-callDatabases & SQLNetworking & APIsSenior–Staff~40 min

You run an active-active multi-region datastore (region-east, region-west) with asynchronous cross-region replication. At 04:00 the inter-region network link degrades — not a clean cut, but packet loss pushes replication lag from <1s to several minutes and flapping. Dashboards: each region still serves local reads/writes fine, but users who write in one region and read from the other (e.g. mobile clients hitting different edges) see their own writes 'disappear,' and a few cross-region operations conflict. Recent context: a backbone provider reported degradation. How do you triage and mitigate?

What a strong answer looks like

Stop the bleeding first (mitigate), then form hypotheses from real signals. Separate root cause from symptom, communicate status as you go, and close with what prevents a repeat.

0:00 of about 40 min
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.