mufassall

Data & storage / 4 / 11

Database replication

A profile service outgrows one database. We add read replicas, meet replication lag and the read-your-writes problem, lose the leader, fail over, and decide what synchronous replication is worth.

  • 13 min
  • Intermediate
  • 10 steps
Request p95
850 ms
Worst replica lag
0 ms
Stale reads
0 %
Commits lost on failover
0
Open in Lab
50%95%
  • request
  • reply
  • redelivery
  • duplicate
  • lost

Numbers are a model scenario, not measurements

The real request

Profile API → DB A

Request

SELECT name, bio FROM profiles
WHERE user_id = 'u_42';1

Response

(1 row)
Time: 640.2 ms2
  1. user_id — A primary-key lookup. Cheap on its own, slow when the server is saturated.
  2. Time — 640 ms for one row: the time is spent waiting for CPU and disk, not on the query.
Course: 42 lessons
  1. 01 Foundations

    1. The life of a request
    2. Latency and throughput
    3. Napkin math
  2. 02 Scaling

    1. Scaling up vs scaling out
    2. Load balancing
    3. Stateless servers
    4. Caching
    5. CDN and edge caching
  3. 03 Data & storage

    1. SQL and NoSQL
    2. Database indexes
    3. Storage engines: B-tree and LSM
    4. Database replication
    5. Sharding
    6. Consistent hashing
    7. Unique IDs
    8. CAP: when the link breaks
    9. Consensus and leader election
    10. Transactions
    11. File uploads
  4. 04 Communication

    1. API styles
    2. Message queues
    3. Pub/sub and event logs
    4. Real-time updates
    5. Reliable callbacks
  5. 05 Reliability

    1. Redundancy and failover
    2. Rate limiting
    3. Timeouts and retries
    4. Observability
  6. 06 Architecture

    1. Microservices
    2. Service discovery
    3. Sagas and the outbox
    4. Batch vs stream
  7. 07 Security

    1. Authentication
    2. Authorization
    3. Encryption and secrets
  8. 08 Shipping

    1. Testing
    2. CI/CD: from commit to production
  9. 09 Whole systems

    1. From requirements to design
    2. Design a URL shortener
    3. Design a news feed
    4. Design a chat
  10. 10 Business processes

    1. Payment gateway