Unable to install myrocks storage engine on percona-server 5.7

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hi,

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.
1 Like
2

HI @Saaharjit_Singh
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

1 Like
3

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
1 Like
4

I don’t see rocksdb packages for all similar mysql packages:

https://repo.percona.com/apt/pool/main/p/percona-server-5.7/

@Evgeniy_Patlan Issues with our build system?

1 Like
5

The issue appears as we store only 5 latest versions in our ps-57 repo and only 1 latest version in original repo
https://repo.percona.com/ps-57/apt/pool/main/p/percona-server-5.7/
So if the version is older - then it is needed to download it from website

1 Like
6

@Evgeniy_Patlan It seems like version 5.7.23-25 is missing from the repo
https://repo.percona.com/apt/pool/main/p/percona-server-5.7/

1 Like
7

@Saaharjit_Singh ,
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.

1 Like
8

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

2 Likes