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. ...
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 Mosk ...
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 orga ...
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 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 o ...
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
InnoDB is a 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 transaction features, along with ...
(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
See also
*
RocksDB
*
Comparison of MySQL database engines
This is a comparison between notable database engines for the MySQL database management system (DBMS). A database engine (or "storage engine") is the underlying software component that a DBMS uses to create, read, update and delete
In compute ...
References
External links
Official websiteSource Code repositoryMyRocks users mailing listDocumentation wikiMyRocks in MariaDB documentation
{{Facebook navbox
MySQL
Database engines
Facebook software
Free software