MyRocks

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.

MyRocks
Developer(s)Facebook
Initial release2015 (2015)
Repositorygithub.com/facebook/mysql-5.6
Written inC++
TypeDatabase engine
LicenseGPL 2.0
Websitemyrocks.io

Starting from version 10.2.5, MariaDB includes MyRocks as an alpha-stage storage engine.[1] [2] MariaDB 10.3.7 includes MyRocks as a storage engine.[3]

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

  • 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:[4]

  • 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
gollark: ++exec```haskellmain = putStrLn $ repeat 'e'```
gollark: ++exec```haskellmain = fix error```
gollark: An antimeme is the opposite of a meme, ish. It's a concept which is difficult to remember/think of/pass on.
gollark: 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱 🅱Here is a snapshot of ALL CONVERSATION in 20 years if this continues.
gollark: Fixed.

See also

References
  1. "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.
  2. "MyRocks alpha storage engine added - MariaDB 10.2.5 Release Notes". MariaDB.org. 2017-04-05. Retrieved 2017-08-31.
  3. "MariaDB 10.3.4 Release Notes". MariaDB.com. 2018-01-18. Retrieved 2018-01-19.
  4. "MyRocks: A space- and write-optimized MySQL database". Facebook Code. 2016-08-31. Retrieved 2017-01-06.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.