Range or hash
Difficulty 3 of 5
A log table takes 16,000 events/s, all stamped now. A report reads one account's events from the last hour 200 times/s. Choose how to split four 1-vCPU shards. Keep CPU use below 70 percent and both p99 times below 100 ms.
Options
- Split by time range
- Split by a hash of the event ID
- Split by account hash, ordered by time
Goals and limits
- p99 latency (Append)
- under 100 ms
- p99 latency (Report)
- under 100 ms
- Error rate (*)
- under 0.1%
- CPU use
- under 70%
- Monthly cost
- under 80 USD/mo
- Traffic
- 16,000 req/s
Concepts
How players did
Player results load from the server.