Forum Stats

  • 3,816,286 Users
  • 2,259,165 Discussions
  • 7,893,440 Comments

Discussions

MyRocks Storage Engine for MySQL

User_G3733
User_G3733 Member Posts: 1 Red Ribbon
edited Nov 12, 2018 10:23AM in MySQL Community Space

Hi All,


We are currently doing some R&D on MyRocks storage engine (wiki: https://en.wikipedia.org/wiki/MyRocks ) and evaluating this storage engine over Innodb. It would be helpful if you can provide your expert advisory on below questions relating to MyRocks Storage Engine for MySQL.

- What versions of Oracle MySQL support with MyRocks Storage Engine i.e. 5.6,5.7, 8.0?

- Do Oracle MySQL provide technical support for MyRocks Storage Engine (on all or any specific MySQL version)?

- Do we have all MySQL Enterprise Features available with MyRocks Storage Engine as we have with Innodb.

- Do we have all MySQL enterprise edition encryption/decryption features (TDE, Innodb tablespace, column-level, a/symmetric key based etc.) available with MyRocks storage engine as well? ... as we have with Innodb storage engine.

- Does MyRocks Storage Engine support Master-Master replication and HA/Clustering feature?

Regards.

Best Answer

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Nov 12, 2018 10:23AM Answer ✓

    - What versions of Oracle MySQL support with MyRocks Storage Engine i.e. 5.6,5.7, 8.0?

    Oracle does not support MyRocks

    - Do Oracle MySQL provide technical support for MyRocks Storage Engine (on all or any specific MySQL version)?

    Oracle does not support MyRocks

    - Do we have all MySQL Enterprise Features available with MyRocks Storage Engine as we have with Innodb.

    No.

    - Do we have all MySQL enterprise edition encryption/decryption features (TDE, Innodb tablespace, column-level, a/symmetric key based etc.) available with MyRocks storage engine as well? ... as we have with Innodb storage engine.

    No.

    - Does MyRocks Storage Engine support Master-Master replication and HA/Clustering feature?

    You could build that on top of MyRocks but that is something you would have to do.

    If you really need MyRocks, contact your salesperson and let them know plus go to bugs.mysql.com and add you voice to the feature request.

    Dave Stokes

    MySQL Community Manager

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited Nov 11, 2018 12:58AM

    facebook develop and support that third paty mysql database engine myrocks.

    You should read the information on the link you posted and the other links it points to, for example MyRocks | A RocksDB storage engine with MySQL | MyRocks , as it answers many of your questions. For example right at the top https://en.wikipedia.org/wiki/MyRocks t says:

    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.

    An interesting feature of mysql is that one installation can support multiple and different database engines, so you could set it up with innodb AND rocksdb,

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Nov 12, 2018 10:23AM Answer ✓

    - What versions of Oracle MySQL support with MyRocks Storage Engine i.e. 5.6,5.7, 8.0?

    Oracle does not support MyRocks

    - Do Oracle MySQL provide technical support for MyRocks Storage Engine (on all or any specific MySQL version)?

    Oracle does not support MyRocks

    - Do we have all MySQL Enterprise Features available with MyRocks Storage Engine as we have with Innodb.

    No.

    - Do we have all MySQL enterprise edition encryption/decryption features (TDE, Innodb tablespace, column-level, a/symmetric key based etc.) available with MyRocks storage engine as well? ... as we have with Innodb storage engine.

    No.

    - Does MyRocks Storage Engine support Master-Master replication and HA/Clustering feature?

    You could build that on top of MyRocks but that is something you would have to do.

    If you really need MyRocks, contact your salesperson and let them know plus go to bugs.mysql.com and add you voice to the feature request.

    Dave Stokes

    MySQL Community Manager