Lesson 5

Why indexes?

Break it

A small shop with little traffic. Turn it up to 400 requests per second.

Users
100 req/s
Load balancer
splits evenly
0%
App servers
× 2
5%
Cache
Not added
Off
DB primary
reads + writes · no index
32%
Read replicas
None
Off
100 req/s
p50 latency
379 ms
Failed requests
0.0%
Monthly cost
$220