MyRocks

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
MyRocks
Myrocks-logo.png
Developer(s)Facebook
Initial release2015; 3 years ago (2015)
Repositorygithub.com/facebook/mysql-5.6
Written inC++
TypeDatabase engine
LicenseGPL 2.0
Websitemyrocks.io

MyRocks is open-source software developed at Facebook in order to use MySQL features with RocksDB implementations. It is based on Oracle MySQL 5.6.

Percona is making MyRocks more accessible to users by bringing it to Percona Server.[1] Starting from version 10.2.5, MariaDB includes MyRocks as an alpha-stage storage engine.[2] [3] In MariaDB 10.3.4 (in beta), MyRocks is included as a beta storage engine.[4]

The library is maintained by the Facebook Database Engineering Team.

Features[edit]

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.[5]

  • 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[edit]

Benchmark tests against 3 different instances – MyRocks (compressed), InnoDB (uncompressed), and InnoDB (compressed, 8 KB page size) – found:[5]

  • 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[edit]

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[edit]

References[edit]

  1. ^ "Announcing MyRocks in Percona Server for MySQL". Percona Database Performance Blog. 2016-10-24. Retrieved 2017-01-06.
  2. ^ "Thoughts on MariaDB Server 10.3 from MariaDB Developers Meeting in Amsterdam, part 1 - MariaDB.org". MariaDB.org. 2016-10-10. Retrieved 2017-01-06.
  3. ^ "MyRocks alpha storage engine added - MariaDB 10.2.5 Release Notes". MariaDB.org. 2017-04-05. Retrieved 2017-08-31.
  4. ^ "MariaDB 10.3.4 Release Notes". MariaDB.com. 2018-01-18. Retrieved 2018-01-19.
  5. ^ a b "MyRocks: A space- and write-optimized MySQL database". Facebook Code. Retrieved 2017-01-06.

External links[edit]