We really want to play with MyRocks and Percona Server 5.7 seems like the best way to do it, however it doesn’t seem to be possible to install it currently because the APT repository is not consistent.
This blog post indicated that there would be builds for Ubuntu 16.04 Xenial. https://www.percona.com/blog/2017/09/06/myrocks-percona-server-mysql/
I followed the instructions here https://www.percona.com/doc/percona-server/LATEST/myrocks/install.html that indicated that experimental builds have to be enabled in the APT sources config.
Installing Percona Server 5.7 installs percona-server-server-5.7 (5.7.19-17-1.xenial) - all good so far.
Trying to install the RocksDB plugin is where we run into issues:
percona-server-rocksdb-5.7 : Depends: percona-server-server-5.7 (= 5.7.19-29.22-1.xenial) but 5.7.19-17-1.xenial is to be installed
RocksDB seems to depend on a version of Percona Server that is not in the repository. To see what was going on, I started to look in the APT meta files.
I found the Xenial RocksDB files in the percona-xtradb-cluster-5.7 folder (http://repo.percona.com/apt/pool/experimental/p/percona-xtradb-cluster-5.7/percona-server-rocksdb-5.7_5.7.19-29.22-1.xenial_amd64.deb) which seemed weird - first, that the file would be in that folder instead of percona-server-server-5.7; second, that even though the dependency was set to percona-server-server-5.7, the version specified (5.7.19-29.22) seems to be a percona-xtradb-cluster-5.7 version; third, that the file itself was only 5KB and contained only a changelog.
Looking in the repo a little more, I do find a build for zesty (Ubuntu 17.04) that seems like it could work.
The file is in the right folder, points to the right Percona Server 5.7 version and is large enough that I could see it containing the plugin.
What should I do if I want to get this running on Ubuntu 16.04? I may look into setting up a Zesty server to get this working…
Thanks for the help!