Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MyRocks Engineering: deploying a new MySQL storage engine to production at Facebook

Sponsor Percona Live Open Source Database Conference

MyRocks Engineering: deploying a new MySQL storage engine to production at Facebook

 25 April - 5:15 PM - 5:40 PM @ Ballroom B
Experience level: 
Intermediate
Duration: 
25 minutes conference
Tracks:
Business / Case Studies
Developer
Topics:
RocksDB
MySQL
Devops
High Availability

Description

MyRocks is a Facebook project to integrate the RocksDB LSM storage engine into MySQL. In the past, we have covered basic functionality and performance benefits of MyRocks. In this talk, we'll cover new features of MyRocks necessary to meet our scaling requirements. We have reduced data load times for the storage engine and added better diagnostic capabilities. We have found and fixed various performance and data consistency issues in RocksDB. We will also highlight the various challenges we faced deploying the MyRocks storage engine to Facebook's social graph infrastructure. We will discuss the test systems we've built to verify the correctness of the storage engine. Some of these test systems utilized full production traffic, allowing us to tune MyRocks settings and preemptively resolve performance issues related to them.

Speakers

Herman Lee

Software Engineer, Facebook Inc.

Biography:

Herman is a software engineer at Facebook who worked on the company’s memcache infrastructure before joining the MyRocks project. Prior to Facebook, he developed storage products at NetApp and Cisco.

Share this talk