Problems / Databases, easy

Slow database rescue

The database answers reads in 9 seconds. The API gives up after 5 seconds and retries twice.

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

Your goals

Bring success to ≥ 99% and Apdex to ≥ 0.90. Try the 9 ms preset, then 200 ms.

The traffic

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

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 5.0 s
PostgresSQL databaseAPI calls it.Postgres runs one process per connection, which is why poolers like PgBouncer sit in front of busy databases.8 vCPU · 50 connections

More databases problems