Using RocksDB with MariaDB

This will seem to work well with Ignition, but eventually problems creep up and you'll get a lot of database errors. So, while this will be kept for posterity, don't use this for Ignition's historian.

Windows

Installation/Removal

Installing the Plugin using the my.ini file (Preferred)

[mysqld]
plugin_load_add=ha_rocksdb
rocksdb-override-cf-options='default={compression=kZlibCompression;bottommost_compression=kZlibCompression;}'
default-storage-engine=ROCKSDB

Installing the Plugin using a Query

INSTALL SONAME 'ha_rocksdb';

Removing the Plugin using a Query

UNINSTALL SONAME 'ha_rocksdb';

Common

Check the plugin is installed

SELECT * FROM information_schema.plugins WHERE plugin_name='ROCKSDB'

SHOW VARIABLES LIKE 'rocksdb_supported_compression_types';

SHOW PLUGINS;

SELECT * FROM information_schema.rocksdb_cf_options WHERE option_type LIKE '%ompression%' AND cf_name='default';