MariaDB 10.3 with MyRocks

Ben S

• January 20, 2019 20:22

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.

• 

  Ben S

  • January 21, 2019 03:30

  Following up, the PHP app reporting the old version of MariaDB must have just been caching, it's showing the correct version now.

  0
• 

  cPanelMichael

  • January 21, 2019 17:51

  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: 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: plugin-load-add=ha_rocksdb.so
  3. Restart MariaDB via the following command: /scripts/restartsrv_mysql
  You should then see RocksDB as a supported MariaDB engine. EX: # 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.

  0

Please sign in to leave a comment.