B-tree or LSM

  • Choose
  • Store 04

Difficulty 1 of 5

One stream appends 6,000 metric values/s. A separate catalog serves 4,000 indexed reads/s. Each store gets 1 vCPU. Choose where each workload lives. Keep p99 below 100 ms for both and the cost at or below 80 USD/month.

Play level

Options

  • Relational B-tree engine for both
  • Metric values as objects; relational catalog
  • LSM key-value metrics; relational catalog
A disk that fillsArrow keys change the write rate. Tap to ship the logs.

Goals and limits

p99 latency (Metrics)
under 100 ms
p99 latency (Catalog)
under 100 ms
Monthly cost
under 80 USD/mo
Traffic
6,000 req/s

Concepts

How players did

Player results load from the server.

All levels