conferences | speakers | series

RocksDB Storage Engine for MySQL

home

RocksDB Storage Engine for MySQL
FOSDEM 2016

At Facebook, we have been developing and using the RocksDB storage engine in a number of different services and applications.

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.

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.

Speakers: Yoshinori Matsunobu