MyRocks deep dive and production deployment at Facebook

on YouTube ↗51m

" summary

MyRocks (a RocksDB-based MySQL storage engine) and its production deployment at Facebook are examined, covering features added such as Blind Deletes and TTL. The talk explains migration strategies from InnoDB and HBase into MyRocks for Facebook’s main UDB and Messenger services, the implementation details of those features, operational behavior in production, and challenges encountered with their solutions.

AI-written summary · about

" chapters (6)

1. 0:00Introduction
2. 10:27MyRocks overview
3. 20:01Production deployment
4. 30:14Messenger use case
5. 40:22Performance testing
6. 50:12Q&A

" related talks

• 47mLessons Learned from Our Main Database Migrations at FacebookYoshinori Matsunobu · SREcon18 Asia/Australia
• 12mMyRocks at Facebook and a RoadmapYoshinori Matsunobu · Percona Live Open Source Database Conference Europe 2017
• 50mInnoDB to MyRocks Migration in Main MySQL DatabaseYoshinori Matsunobu · SREcon17 Asia/Australia
• 52mRocksDB Performance and Reliability PracticsYoshinori Matsunobu · Percona Live 2022
• 57mRocksDBMark Callaghan, Igor Canadi · The Databaseology Lectures (Fall 2015)
• 39mLessons Learned from Our Main Database MigrationsYoshinori Matsunobu · SREcon18 Americas
• 45mMyRocks Table Engine for MySQLAleksey Maykov, Sergey Petrunya · HighLoad++ 2015
• 27mMyRocks: best practice at Alibaba - MySQL Storage Enginejiayi wang, dengcheng he · Percona Live Open Source Database Conference 2017