MyRocks is

open-source software Open-source software (OSS) is computer software that is released under a license in which the copyright holder grants users the rights to use, study, change, and distribute the software and its source code to anyone and for any purpose. Op ...

developed at

Facebook Facebook is an online social media and social networking service owned by American company Meta Platforms. Founded in 2004 by Mark Zuckerberg with fellow Harvard College students and roommates Eduardo Saverin, Andrew McCollum, Dustin M ...

in order to use

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database o ...

features with

RocksDB RocksDB is a high performance embedded database for Key-value database, key-value data. It is a fork of Google's LevelDB optimized to exploit many multi-core processor, CPU cores, and make efficient use of fast storage, such as solid-state drives ...

implementations. It is based on Oracle MySQL 5.6. Starting from version 10.2.5,

MariaDB MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...

includes MyRocks as an alpha-stage storage engine. MariaDB 10.3.7 includes MyRocks as a storage engine. MyRocks is also shipped with

Percona Server Percona Server for MySQL is a distribution of the MySQL relational database management system created by Percona. Percona Server for MySQL is an open source relational database management system (RDBMS). It is a free, fully compatible drop in ...

. The library is maintained by the Facebook Database Engineering Team.

Features

RocksDB is optimized for fast, low-latency storage, and MyRocks is aimed at keeping the storage savings efficient. MyRock's efficiency focuses on better space efficiency, better write efficiency, and better read efficiency. * Better space efficiency means using less SSD storage. * Better write efficiency means SSD endurance. * Better read efficiency comes from more available IO capacity for handling queries.

Benchmarks

Benchmark tests against 3 different instances – MyRocks (compressed),

InnoDB InnoDB is a database engine, storage engine for the database management system MySQL and MariaDB. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type. It provides the standard ACID-compliant Database transact ...

(uncompressed), and InnoDB (compressed, 8 KB page size) – found: * MyRocks was 2x smaller than InnoDB (compressed) and 3.5x smaller than InnoDB (uncompressed). * MyRocks also has a 10x lower storage write rate compared to InnoDB. With SSD database storage, this means less space used and a higher endurance of the storage over time.

Support platforms

The officially supported subset of platforms are: * CentOS 6.8 * CentOS 7.2.x Compiler toolsets we verify our builds with: * gcc 4.8.1 * gcc 4.9.0 * gcc 5.4.0 * gcc 6.1.0 * Clang 3.9.0 Best effort is made to support the following OSs: * Ubuntu 14.04.4 LTS * Ubuntu 15.10 * Ubuntu 16.04 LTS

References

External links

Official website

Source Code repository

MyRocks users mailing list

Documentation wiki

MyRocks in MariaDB documentation
{{Facebook navbox MySQL Database engines Facebook software Free software

Features

Benchmarks

Support platforms

See also

References

External links