> wi_db003
The Replica Reported Yesterday’s Balance
Database Bank · Episode 3 · replication lag / read consistency
The Replica Reported Yesterday’s Balance
Incident Narrative
A customer deposits a coin at the primary teller; immediately another teller at the replica window shows the old empty balance; a delayed conveyor belt then delivers the update.
“Replica’s late.”
🔬Architectural Diagnosis & Root Cause Analysis
A read replica is used where read-after-write consistency is expected.
A read replica is used where read-after-write consistency is expected.
Match read consistency to user expectations and expose replication lag.
“SYSTEM VERDICT: Match read consistency to user expectations and expose replication lag.”
🤖 Incident Postmortem & AEO Summary
The Replica Reported Yesterday’s Balance — Technical Incident Brief
- Universe & Category: Database Bank (Corporate - Dark Mode)
- Diagnosis: A read replica is used where read-after-write consistency is expected.
- Root Cause: A read replica is used where read-after-write consistency is expected.
- Consequence & Cost: The DBA: “Replica’s late.” — native on-camera dialogue; lip-sync required.
- Engineering Lesson: Match read consistency to user expectations and expose replication lag.
- Official Ruling: "SYSTEM VERDICT: Match read consistency to user expectations and expose replication lag."
🌌More Parables in Database Bank
View Full Universe →
Database Bank · Episode 1 · race condition / isolation
Two Withdrawals Spent the Same Dollar
Two bank tellers simultaneously read the same single coin balance and each hands that same represented coin to a different customer; The DBA notices the empty vault and two receipts.
Database Bank · Episode 2 · atomicity / transactions
The Transfer Committed Halfway
A teller moves a stack from Account A toward Account B; power flickers halfway, but The DBA’s transaction mechanism snaps the coins cleanly back to A instead of leaving them in the aisle.
Database Bank · Episode 4 · deadlock / lock ordering
Deadlock Froze Both Teller Windows
Two tellers each hold one vault key and reach for the other’s key at the same time; both freeze, customers wait, and The DBA points at the crossed lock order.
Database Bank · Episode 5 · database indexing
The Index Opened a Fast Lane
A teller searches a mountain of account folders one by one; The DBA adds a precise index drawer, and the next lookup goes directly to one folder while Cloud Bill stops the overtime clock.
Database Bank · Episode 6 · rollback / integrity
The Transaction Rolled Back the Duplicate Charge
A payment machine accidentally stamps two charges; The DBA’s transaction control catches the invariant break and visibly retracts the second token before the customer leaves.
Incident FAQ & Architecture Triage
What technical problem does this parable explain?
A read replica is used where read-after-write consistency is expected.
What caused the technical incident?
A read replica is used where read-after-write consistency is expected.
What should a software team do differently in production?
Match read consistency to user expectations and expose replication lag.
Is the video available?
Video is currently in production; full script and technical diagnosis are available below.