156. Design an Embedded Storage Engine like RocksDB

The brief

Design an Embedded Storage Engine like RocksDB. An LSM-tree key-value engine inside its caller: a WAL and a memtable, levelled compaction, filters and caches, then one engine per node under Raft. Work from the scoping questions below. State assumptions for any unspecified load, guarantee or target, then trace your design end to end. Explain one difficult case and a credible alternative; the worked example is a reference, not a required implementation.

• Set the scope: Data and traffic? What do reads look like?
• Define the contract: Durability? Latency?
• Test the boundaries: Hardware? Several key spaces with different needs? Read-modify-write?

Constraints

Explicit scope and guarantees

Resolve the scoping questions for an Embedded Storage Engine like RocksDB. Separate stated behavior from assumptions, and identify what is outside your design.

Supported operating targets

Declare relevant volume, latency, freshness, quality or cost targets with units. Show calculations or an evaluation plan that can test them; unspecified targets are your assumptions, not hidden pass criteria.

Failure and boundary behavior

Explain how your guarantees hold in a difficult case relevant to this subject. Address: Several key spaces with different needs? Read-modify-write?

What to cover

1. 01

   Scope and behavior contract

   Identify users, required behavior and exclusions. Answer: Data and traffic? What do reads look like?

2. 02

   State and interfaces

   Define the information owned by the system and the inputs, outputs and errors at its boundaries. Resolve: Durability? Latency?

3. 03

   Capacity and operating targets

   Estimate the dominant workload and resource demand with units and explicit assumptions. For a learned system, also state how quality is measured and what data is available.

4. 04

   Architecture and central flow

   Draw or describe the responsibilities needed for an Embedded Storage Engine like RocksDB. Trace a representative request, event or job from its input to a visible result; identify durable state owners.

5. 05

   Failure and boundary walkthrough

   Walk through a difficult case step by step, including detection and recovery. Consider: Hardware? Several key spaces with different needs? Read-modify-write?

6. 06

   Tradeoffs and operations

   Compare a credible alternative using your chosen workload and guarantees. Explain a remaining risk, a signal to watch and when you would change the design.

Worked designs

Explore the architecture and decisions, then build on an example with Coach.

Official design

Design an Embedded Storage Engine like RocksDB

An LSM-tree key-value engine inside its caller: a WAL and a memtable, levelled compaction, filters and caches, then one engine per node under Raft: one-hour boards for junior, senior and staff, with the theory behind them.

Explore the design

Review rubric

AI feedback uses these criteria. Scores are practice feedback.