MyRocks For Percona Server
Written by Kay Ewbank   
Friday, 08 December 2017

There's an experimental release of MyRocks in Percona Server for MySQL 5.7, with packages. MyRocks is open source software that was developed at Facebook to provide a way to use MySQL features with Facebook's RocksDB. It is also used in MariaDB as a storage engine.

Facebook uses MySQL, and developed RocksDB as an embeddable, persistent key-value store for fast storage as an alternative to InnoDB as the storage engine.

The problem then arose that RocksDB does not support replication or an SQL layer, and Facebook wanted to continue using those features from MySQL. This led to the development of MyRocks as an open source project that integrates RocksDB as a new MySQL storage engine. When Facebook migrated its user database tier to MyRocks from InnoDB, it was able to use 50 percent less storage for the same amount of data compared with compressed InnoDB.

Alongside the better compression, MyRocks offers faster replication than InnoDB. This is partially because MyRocks doesn't need random reads for updating secondary keys, unless the index is unique. Also, with the row-based binary logging format, MyRocks does not need random reads for updating primary keys, and does not even need to check uniqueness.

MyRocks is also faster at data loading because it writes data directly onto the bottommost level, which avoids all compaction overheads. Because compactions use both CPU and I/O for decompressing, compressing, and writing data, avoiding compactions by bulk loading is optimal.

MyRocks does lack a number of features, including foreign keys, online DDL, automatic deadlock detection, and native partitioning. It also lacks interesting features that are native in InnoDB like FULLTEXT and SPATIAL indexes.

Facebook's plans for MyRocks include cross-engine support rather than adding what the developers describe as 'niche features'. This will make it possible to run both InnoDB and MyRocks in the same instance, using InnoDB for small, read-intensive tables, and MyRocks for everything else. There are also plans to support MyRocks for the upcoming MySQL 8.0.

Percona MyRocks is distributed as a separate package that can be enabled as a plugin for Percona Server for MySQL 5.7.19-17. It is available for Debian 8 and 9, Ubuntu, and Red Hat Enterprise Linux or CentOS.

 

myrocks

 

More Information 

MyRocks Website

Percona Server for MySQL

Related Articles

Facebook Open Sources Two Technologies

RocksDB on Steroids

RocksDB - Facebook's Database Now Open Source 

 

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, Facebook or Linkedin.

 

Banner


How Gen Z Could Fill the Skills Gap
27/03/2019

HackerRank's Women in Tech 2019 report focuses attention on Gen Z women, born from 1997 onwards. As they are reaching their early twenties, they are beginning to enter the workforce en masse. 



Picking, Packing, Delivery - All By Robots
30/03/2019

Robots are beginning to have a real impact in logistics, relieving humans of arduous or repetitive tasks. Here are some of the very latest developments that take picking and packing further along [ ... ]


More News

 

Python

 



 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Friday, 08 December 2017 )