Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MariaDB 10.3 with MyRocks

Discussion in 'Database Discussion' started by Ben S, Jan 20, 2019.

  1. Ben S

    Ben S Registered

    Joined:
    Jan 20, 2019
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I just upgraded my VPS to cPanel 78.0.1 so I could run MariaDB 10.3.

    I was hoping to be able to test converting tables to the MyRocks storage engine, which is included in 10.3, I didn't see the option.

    I also notice my PHP app is reporting the DB server as MySQL(i) 10.2.21-MariaDB-log when everything else is saying 10.3.12-MariaDB-log - MariaDB Server.

    I'm curious if both of these are expected, since this is pretty new to cPanel.
     
  2. Ben S

    Ben S Registered

    Joined:
    Jan 20, 2019
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    Following up, the PHP app reporting the old version of MariaDB must have just been caching, it's showing the correct version now.
     
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Ben S,

    The rocksdb MariaDB storage engine isn't supported or enabled by default when MariaDB 10.3 is installed on a cPanel & WHM server. However, you can enable it using the steps below:

    1. Install the MariaDB-rocksdb-engine RPM via the following command:

    Code:
    yum install MariaDB-rocksdb-engine
    2. Use vi or nano to add the following line under the [mysqld] section in the /etc/my.cnf file:

    Code:
    plugin-load-add=ha_rocksdb.so
    3. Restart MariaDB via the following command:

    Code:
    /scripts/restartsrv_mysql
    You should then see RocksDB as a supported MariaDB engine. EX:

    Code:
    # mysql
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 9
    Server version: 10.3.12-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> show engines;
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    | ROCKSDB            | YES     | RocksDB storage engine                                                           | YES          | YES  | YES        |
    | CSV                | YES     | Stores tables as CSV files                                                       | NO           | NO   | NO         |
    | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
    | MyISAM             | DEFAULT | Non-transactional engine with good performance and small data footprint          | NO           | NO   | NO         |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
    | InnoDB             | YES     | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
    | SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    9 rows in set (0.001 sec)
    
    Keep in mind this is an unsupported configuration, so you should always backup your databases before performing the above steps.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Ben S likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice