Skip to solution
mediumSystem Design

What is database replication?

537 views
01

Understand the problem

Explain replication and read replicas.

replication
02

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Nudge consolestandby

Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.

03

Study the solution

What Is Database Replication?

Target Audience: Junior & Senior Software Engineers preparing for System Design Interviews — no prior system design knowledge assumed. Difficulty: Medium

How to read this doc: Every concept is explained in plain language first. Right after, you'll see a callout like `📌 I

Solution ready — 2 min read

Classified // press E to declassify

04

Read the code

Read routing with read-your-writes
Run Playground
// Route reads to a follower for scale, but send a user to the leader
// briefly after they write so they never see their own stale data.
function pickReadDB(userId, lastWriteAt) {
  const RECENT_MS = 3000; // longer than typical replication lag
  if (Date.now() - (lastWriteAt[userId] ?? 0) < RECENT_MS) {
    return leader;        // read-your-writes: hit the primary
  }
  return followers[Math.floor(Math.random() * followers.length)];
}
05

Join the discussion

Discussion (0)

Sign in to join the discussion.

No responses yet. Be the first to share what you think.

Transmission complete // awaiting log

KEEP THE
STREAK ALIVE.

Dossier 28 of 99 decoded in the System Design track. One more won't hurt.

Back to track