Herman Lee, Software package Engineer from Fb Inc. delivers their discuss, “MyRocks Engineering: deploying a new MySQL storage engine to generation at Facebook”, on Working day 1 of the Percona Live Open up Source Database Conference 2017, 4/25, at Santa Clara, CA.
MyRocks is a Facebook undertaking to integrate the RocksDB LSM storage motor into MySQL. In the previous, we have covered simple performance and functionality benefits of MyRocks. In this discuss, we will address new capabilities of MyRocks important to meet up with our scaling requirements. We have lessened knowledge load moments for the storage engine and included improved diagnostic abilities. We have discovered and set many overall performance and knowledge consistency problems in RocksDB.
We will also emphasize the different issues we confronted deploying the MyRocks storage motor to Facebook’s social graph infrastructure. We will explore the test methods we’ve constructed to validate the correctness of the storage motor. Some of these test techniques used comprehensive creation site visitors, enabling us to tune MyRocks settings and preemptively take care of overall performance challenges relevant to them.