Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MyRocks Deep Dive

MyRocks Deep Dive

 24 April - 9:30 AM - 12:30 PM @ Room 203
Experience level: 
3 hours tutorial


This is a tutorial about MyRocks: RocksDB Storage Engine for MySQL ( MyRocks is a project to utilize space and write optimized LSM database with MySQL. MyRocks supports lots of useful features like below. - Less than half space compared to compressed InnoDB - Much smaller write amplification compared to InnoDB - Reverse order index so that descending scan can be a lot faster - Crash safe slave and master - Maitaining optimizer statistics without index dive - Built-in online backup tool - PostgreSQL-style transaction isolation support (Read Committed and Repeatable Read) - Efficient lookup and prefix seek with bloom filter MyRocks is a fully open source database. Supplemental tools, such as online backup tool, are also open sourced. At Facebook, we deployed MyRocks in production in 2016, and are increasing usage. In this 3-hour tutorial, the speaker will give MyRocks and RocksDB deep dive talk. The following topics will be covered. - What is RocksDB - Differences between B+Tree and LSM - MyRocks advantages over InnoDB - MyRocks limitations - Installing MyRocks on Linux machine - Schema design and column families - Configurations - Performance tuning - Backup and recovery - Use cases at Facebook Minimum technical requirements for attendees are basic understanding of InnoDB and MySQL Replication.


Yoshinori Matsunobu's picture

Yoshinori Matsunobu

Database Engineer, Facebook


Yoshinori is a database engineer at Facebook. Before joining Facebook, Yoshinori was a database and infrastructure architect at DeNA, living in Tokyo. Yoshinori's primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.

Share this talk