mediumSystem Design

What is database replication?

533 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.

Stuck? AI Nudge Available

Get a conceptual hint to guide your logic without spoiling the final implementation.

03

Study the solution

The solution is waiting

Give it an honest attempt first — then compare your thinking with the full walkthrough.

04

Read the code

Read routing with read-your-writes
// 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.