LSM Databases at Facebook

MySQL Case Studies
15 April 4:30PM - 5:20PM @ Ballroom E

Experience level: 
Intermediate
Duration: 
50 minutes conference

Rate This Session

LSM - Log Structured Merge tree databases - is getting well known to database communities. Compared to traditional databases like InnoDB, LSM is optimized for writes, and has penalties for reads. The most popular LSM database in the world is probably HBase. LSM is not unrelated to MySQL. MySQL has pluggable storage engine architecture, and there are already a couple of storage engines supporting LSM. At Facebook, we use InnoDB for majority of applications, but also use LSM databases for some services, especially for write intensive ones. The speaker will cover the following topics. - What is LSM - Architecture differences compared to InnoDB - LSM databases -- HBase and RocksDB - RocksDB Storage Engine for MySQL - Some benchmark numbers - Case Studies at Facebook


Speakers

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.