MyRocks: A space- and write-optimized MySQL database

What this post added

Introduced MyRocks, a new open-source MySQL storage engine that integrates RocksDB as a backend. MyRocks offers significant improvements in space efficiency (50% less storage compared to compressed InnoDB) and reduced write amplification by leveraging RocksDB's LSM-tree structure, append-only nature, and prefix key encoding. Benchmarks show MyRocks is two times smaller than compressed InnoDB and writes orders of magnitude less. The post also details the migration process from InnoDB to MyRocks in production without downtime.