2 Replies Latest reply on Nov 12, 2018 3:23 PM by Dave Stokes-MySQL Community Team-Oracle

    MyRocks Storage Engine for MySQL

    3652710

      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.

        • 1. Re: MyRocks Storage Engine for MySQL
          Gaz in Oz

          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,

          • 2. Re: MyRocks Storage Engine for MySQL
            Dave Stokes-MySQL Community Team-Oracle

            - 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.