Problems / Real world, medium

Chat history on one database

A messaging app stores every message and reads conversation history from one database: 70% reads at 2,000 req/s.

Free to open. Runs in your browser, no sign-up.

Your goals

Success ≥ 99%, p99 ≤ 500 ms.

The traffic

2,000 requests a second for 30 seconds: 70% reads, 30% writes.

The system

What each component does in this design, and what calls it. The simulator mimics each one from these settings.

ComponentIts job hereSettings
Load balancerLoad balancerTraffic enters here.Calls API.Layer 4 balancers route by IP and port; layer 7 balancers read HTTP and can route by path or header.–
APIApp serviceLoad balancer forwards to it.Calls Postgres.Little's law: throughput ≈ concurrency ÷ latency. 200 slots at 50 ms serve about 4,000 req/s.3 replicas × 200 slots · timeout 1.0 s
PostgresSQL databaseAPI calls it.Postgres runs one process per connection, which is why poolers like PgBouncer sit in front of busy databases.2 vCPU · 60 connections

Hints

Try it first. Open one hint at a time if you get stuck.

Hint 1

History is read far more than written.

Hint 2

Recent conversations are hot.

One way to solve it

Add read replicas (or cache recent history).

More real world problems