MyRocks Internals and Production Deployment at Facebook

Tuesday 3:20PM-4:10PM

@ Swift Suite 2

MySQL / MariaDB

50 minutes conference

Intermediate

Tracks:
Developer, Operations

At Facebook, we open sourced MyRocks?Flash optimized, space and write efficient MySQL database engine. We are in the process of migrating our main MySQL databases?storing Facebook social graphs, massively sharded, low latency and automated services?from InnoDB to MyRocks. We have been very successful so far and have reduced database size by half.

Compared to deploying new database software into new or non-critical services, replacing existing stable database running on very critical services is much harder. You need to pay attention to lots of things, like how to migrate existing data without stopping or slowing down services, how to migrate within reasonable amount of time, and how to continuously verify not to corrupt any data.

In this session, the speaker will talk about MyRocks production deployment story. The following topics will be covered

- Overview of MySQL at Facebook
- What is MyRocks, and why we decided to create yet another database engine
- How Facebook MySQL SRE team collaborated with Engineering team
- How we prepared, executed and monitored InnoDB to MyRocks migration
- Lessons learned from the migration


Speakers

Yoshinori Matsunobu

Yoshinori Matsunobu (Facebook)

Production Engineer

Biography:

Yoshinori Matsunobu is a Production Engineer at Facebook, and now is leading MyRocks project. Yoshinori has been around MySQL community for over 10 years, and was a senior consultant at MySQL Inc since 2006 to 2010. Yoshinori created a couple of useful open source product/tools, including MHA (automated MySQL master failover tool) and quickstack.


Percona Live

Percona Live Europe starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA