At Facebook, we have been developing and using the RocksDB storage engine in a number of different services and applications. The MySQL on RocksDB (MyRocks) project integrates this library as a plugin into MySQL, the database server which we use to store our social graph data. We have found using a write optimized log structured merge tree design, when compared to the B+ tree implementation of InnoDB, reduces the space utilization and write rates of our production servers by half.

The goal of this talk is to introduce some background on the MyRocks project and some of the features we've added to MySQL and RocksDB to support our production environment. We will also introduce some of the performance data gathered from our testing and discuss what the tradeoffs are for using RocksDB vs. InnoDB.