Help Build/Install MyRocks from Source

[Mark Rambacher]

I am new to MyRocks and am trying to build MyRocks from source and do some simple tests based on extensions from RocksDB.  I am running on an Ubuntu virtual machine.

I built MyRocks via:

cmake . -DCMAKE_BUILD_TYPE=Debug -DWITH_SSL=system -DWITH_ZLIB=bundled -DMYSQL_MAINTAINER_MODE=0 -DENABLE_DTRACE=0 -DWITH_ZSTD=/usr

make

After the build, I did a make install, which copied the binaries into /usrl/local/mysql

I then did a mysql_install_db with my CNF file, which ran to completion and did not seem to produce any errors.

When I try to invoke mysqld, it fails with:

2020-02-03 19:45:59 4950 [ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed.

2020-02-03 19:45:59 4950 [ERROR] Unknown/unsupported storage engine: rocksdb

2020-02-03 19:45:59 4950 [ERROR] Aborting

How do I go about installing the RocksDB storage engine?  From the build directories, I can see a librocksdb_se.a and a librocksdb_se_embedded.a.  Based on everything I can find online, I would have expected to find some rocksdb.so files, but there are none.  There are no files (or even a directory) under /usr/local/mysql/storage.

What am I doing incorrectly?   Any assistance would be greatly appreciated.

/ Mark

[Matsunobu Yoshinori]

We generally recommend using MariaDB or Percona Server with MyRocks, rather than building from source. Have you tried either of them?

Could you show my.cnf outputs? Here is an example my.cnf.
https://github.com/facebook/mysql-5.6/wiki/Getting-Started-with-MyRocks

- Yoshinori