M|19

Yoshinori Matsunobu

Yoshinori Matsunobu

Yoshinori Matsunobu

Database Engineer
Facebook

Yoshinori Matsunobu is a Production Engineer at Facebook, and is leading MyRocks project and deployment. Yoshinori has been around MySQL community for over 10 years. He 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.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

Facebook created MyRocks, and it is now available in MariaDB. MyRocks is a space and write optimized storage engine built on top of RocksDB. The initial objective was to replace InnoDB with MyRocks in the users database (UDB), reducing the amount of storage space needed by half. It was a success, and now Facebook is trying to make it better and help increase adoption in other services. In this session, Yoshinori will explain how Facebook replaced InnoDB with MyRocks in UDB, and highlight the features being developed and planned for future releases of MyRocks.

Wednesday, April 12
10:00 am - 10:50 am

In this session, I'll discuss how we migrated from InnoDB to MyRocks in production at Facebook, for both slave and master instances, without stopping services, losing data, or returning incorrect results. We created many features for easier migration, such as fast data loading, and a tool that confirms data and query correctness, and runs without affecting online service. I will share lessons learned from our initial migrations and the impact we have seen.