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


Azure AI And Pgvector Run Generative AI Directly On Postgres
26/03/2024

It's a match made in heaven. The Azure AI extension enables the database to call into various Azure AI services like Azure OpenAI. Combined with pgvector you can go far beyond full text search. Let's  [ ... ]



JetBrains AI Assistant - A Welcome Time Saver
28/02/2024

JetBrains AI Assistant saves developers up to eight hours per week and they appreciate its help.  77% of users feel more productive, 75% express that they are happier with their IDE experien [ ... ]


More News

 

raspberry pi books

 

Comments




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

Last Updated ( Friday, 08 December 2017 )