MyRocks is
open-source software
Open-source software (OSS) is Software, computer software that is released under a Open-source license, license in which the copyright holder grants users the rights to use, study, change, and Software distribution, distribute the software an ...
developed at
Facebook
Facebook is a social media and social networking service owned by the American technology conglomerate Meta Platforms, Meta. Created in 2004 by Mark Zuckerberg with four other Harvard College students and roommates, Eduardo Saverin, Andre ...
in order to use
MySQL
MySQL () is an Open-source software, 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 rel ...
features with
RocksDB implementations. It is based on Oracle MySQL 5.6.
Starting from version 10.2.5,
MariaDB
MariaDB is a community-developed, commercially supported Fork (software development), fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Developm ...
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.
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 (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
Per the MyRocks documentation:
The officially supported subset of platforms are:
* CentOS 6.8
* CentOS 7.2.x
Compiler toolsets with which the builds are verified:
* 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
See also
*
RocksDB
*
Comparison of MySQL database engines
References
External links
Official websiteSource Code repositoryMyRocks users mailing listDocumentation wikiMyRocks in MariaDB documentation
{{Facebook navbox
MySQL
MariaDB
Bigtable implementations
Database engines
Facebook software
Free software programmed in C++
Software using the GNU General Public License