I wanted to test out the myrocks storage engine with percona -server5.7. I am trying to follow the instructions listed here but I keep running into the error below. We are currently running Server version: 5.7.23-25 but for some reason it’s looking for a different version.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
percona-server-rocksdb-5.7 : Depends: percona-server-server-5.7 (= 5.7.22-22-1.stretch) but 5.7.23-25-1.stretch is to be installed
E: Unable to correct problems, you have held broken packages.
In order to solve this issue you need to mention the package version in apt command
i.e. apt install percona-server-rocsdb-5.7=5.7.22-22
That doesn’t work either. I get the below error
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Version '5.7.22-22' for 'percona-server-rocksdb-5.7' was not found
I don’t see rocksdb packages for all similar mysql packages:
@Evgeniy_Patlan Issues with our build system?
The issue appears as we store only 5 latest versions in our ps-57 repo and only 1 latest version in original repo
So if the version is older - then it is needed to download it from website
As Evgeniy said, we only keep the latest 5 versions of MyRocks in the repo. The current version of Percona Server is 5.7.36. You are running 5.7.23 which is 13 versions older than latest.
Please go here Download Percona Server for MySQL 5.7 and select your version of MySQL. Then you can download the correct MyRocks package. I do see your version listed with MyRocks.
5.7.23 is very old regardless and you should update to a more modern and more secure version before exploring MyRocks. There have beena great many things fixed in both the server and MyRocks engine since then. Since you are considering an engine change, you should also consider an 8.0 upgrade as 5.7 will be EOL by the end of next year. New development on both the core server and MyRocks is moving forward on the 8.0 series only.
George O. Lorch III
Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup