Percona server missing, can't be installed

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hi community
i’m installing percona server into Almalinux server and following the steps from here:

https://docs.percona.com/percona-server/5.7/installation/yum_repo.html

i did

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

yum install Percona-Server-server-57
Last metadata expiration check: 0:43:18 ago on Wed 03 Aug 2022 11:59:34 AM CEST.
All matches were filtered out by modular filtering for argument: Percona-Server-server-57
Error: Unable to find a match: Percona-Server-server-57

but my grep list not found the name of percona server

yum list | grep percona
percona-release.noarch                                            1.0-27                                                     @@commandline
Percona-Server-57-debuginfo.x86_64                                5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-57-debugsource.x86_64                              5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36.x86_64                                  3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-debugsource.x86_64                      3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-mongos.x86_64                           3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-mongos-debuginfo.x86_64                 3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-server.x86_64                           3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-server-debuginfo.x86_64                 3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-shell.x86_64                            3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-shell-debuginfo.x86_64                  3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-tools.x86_64                            3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-MongoDB-36-tools-debuginfo.x86_64                  3.6.23-13.0.el8                                            percona-release-x86_64
Percona-Server-client-57-debuginfo.x86_64                         5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-rocksdb-57.x86_64                                  5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-rocksdb-57-debuginfo.x86_64                        5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-server-57-debuginfo.x86_64                         5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-shared-57-debuginfo.x86_64                         5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-shared-compat-57.x86_64                            5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-test-57-debuginfo.x86_64                           5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-tokudb-57.x86_64                                   5.7.38-41.1.el8                                            percona-release-x86_64
Percona-Server-tokudb-57-debuginfo.x86_64                         5.7.38-41.1.el8                                            percona-release-x86_64
Percona-XtraDB-Cluster-57-debuginfo.x86_64                        5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-57-debugsource.x86_64                      5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-client-57-debuginfo.x86_64                 5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-full-57.x86_64                             5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-garbd-57.x86_64                            5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-garbd-57-debuginfo.x86_64                  5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-server-57-debuginfo.x86_64                 5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-shared-57-debuginfo.x86_64                 5.7.37-31.57.1.el8                                         percona-release-x86_64
Percona-XtraDB-Cluster-test-57-debuginfo.x86_64                   5.7.37-31.57.1.el8                                         percona-release-x86_64
jemalloc-debuginfo.x86_64                                         3.6.0-1.el8                                                percona-release-x86_64
jemalloc-debugsource.x86_64                                       3.6.0-1.el8                                                percona-release-x86_64
percona-backup-mongodb-agent.x86_64                               0.4.0-1.el8                                                percona-release-x86_64
percona-backup-mongodb-coordinator.x86_64                         0.4.0-1.el8                                                percona-release-x86_64
percona-backup-mongodb-pbmctl.x86_64                              0.4.0-1.el8                                                percona-release-x86_64
percona-toolkit.x86_64                                            3.4.0-3.el8                                                percona-release-x86_64
percona-xtrabackup-24.x86_64                                      2.4.26-1.el8                                               percona-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64                            2.4.26-1.el8                                               percona-release-x86_64
percona-xtrabackup-24-debugsource.x86_64                          2.4.26-1.el8                                               percona-release-x86_64
percona-xtrabackup-80.x86_64                                      8.0.28-21.1.el8                                            percona-release-x86_64
percona-xtrabackup-80-debuginfo.x86_64                            8.0.28-21.1.el8                                            percona-release-x86_64
percona-xtrabackup-80-debugsource.x86_64                          8.0.28-21.1.el8                                            percona-release-x86_64
percona-xtrabackup-test-24.x86_64                                 2.4.26-1.el8                                               percona-release-x86_64
percona-xtrabackup-test-24-debuginfo.x86_64                       2.4.26-1.el8                                               percona-release-x86_64
percona-xtrabackup-test-80.x86_64                                 8.0.28-21.1.el8                                            percona-release-x86_64
percona-xtrabackup-test-80-debuginfo.x86_64                       8.0.6-1.el8                                                percona-release-x86_64
pmm-client.x86_64                                                 1.17.5-1.el8                                               percona-release-x86_64
pmm2-client.x86_64                                                2.29.1-6.el8                                               percona-release-x86_64
proxysql2.x86_64                                                  2.3.2-1.2.el8                                              percona-release-x86_64
qpress.x86_64                                                     11-1.el8                                                   percona-release-x86_64
sysbench.x86_64                                                   1.0.20-6.el8                                               percona-release-x86_64
sysbench-debuginfo.x86_64                                         1.0.20-6.el8                                               percona-release-x86_64
sysbench-debugsource.x86_64                                       1.0.20-6.el8                                               percona-release-x86_64
sysbench-tpcc.x86_64                                              1.0.20-6.el8                                               percona-release-x86_64

any idea?

1 Like
2

Hello, after installing the percona-release package you have to run the command to add the proper repository:

percona-release show
percona-release setup ps57

After you do that the rpm will be available to install via yum

1 Like
3

sorry @igroene but dosen’t work

percona-release show
The following repositories are enabled on your system:
percona - release | noarch
percona - release | x86_64
prel - release | noarch
<*> All done!

 percona-release setup ps57
* Disabling all Percona Repositories
* Enabling the Percona Server 5.7 repository
* Enabling the Percona XtraBackup 2.4 repository
<*> All done!

yum list | grep percona
percona-release.noarch                                            1.0-27                                                     @@commandline
percona-xtrabackup-24.x86_64                                      2.4.26-1.el8                                               pxb-24-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64                            2.4.26-1.el8                                               pxb-24-release-x86_64
percona-xtrabackup-24-debugsource.x86_64                          2.4.26-1.el8                                               pxb-24-release-x86_64
percona-xtrabackup-test-24.x86_64                                 2.4.26-1.el8                                               pxb-24-release-x86_64
percona-xtrabackup-test-24-debuginfo.x86_64                       2.4.26-1.el8                                               pxb-24-release-x86_64

yum install Percona-Server-server-57
Last metadata expiration check: 0:00:12 ago on Wed 03 Aug 2022 01:27:06 PM CEST.
All matches were filtered out by modular filtering for argument: Percona-Server-server-57
Error: Unable to find a match: Percona-Server-server-57
1 Like
4

Can you check the contents of the .repo files in /etc/yum.repos.d/ ? You might have some exclude argument.

grep -i exclude /etc/yum.repos.d/*.repo

1 Like
5

not show anything

[root@server ~ ] grep -i exclude /etc/yum.repos.d/*.repo
[root@server ~ ]

[root@server ~] cat /etc/yum.repos.d/percona-*
#
# This repo is managed by "percona-release" utility, do not edit!
#
[percona-release-x86_64]
name = Percona Original release/x86_64 YUM repository
baseurl = http://repo.percona.com/percona/yum/release/$releasever/RPMS/x86_64
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

[percona-release-noarch]
name = Percona Original release/noarch YUM repository
baseurl = http://repo.percona.com/percona/yum/release/$releasever/RPMS/noarch
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

[percona-release-sources]
name = Percona Original release/sources YUM repository
baseurl = http://repo.percona.com/percona/yum/release/$releasever/SRPMS
enabled = 0
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

#
# This repo is managed by "percona-release" utility, do not edit!
#
[prel-release-noarch]
name = Percona Release release/noarch YUM repository
baseurl = http://repo.percona.com/prel/yum/release/$releasever/RPMS/noarch
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

#
# This repo is managed by "percona-release" utility, do not edit!
#
[prel-release-noarch]
name = Percona Release release/noarch YUM repository
baseurl = http://repo.percona.com/prel/yum/release/$releasever/RPMS/noarch
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

#
# This repo is managed by "percona-release" utility, do not edit!
#
[ps-57-release-x86_64]
name = Percona Server 5.7 release/x86_64 YUM repository
baseurl = http://repo.percona.com/ps-57/yum/release/$releasever/RPMS/x86_64
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

[ps-57-release-sources]
name = Percona Server 5.7 release/sources YUM repository
baseurl = http://repo.percona.com/ps-57/yum/release/$releasever/SRPMS
enabled = 0
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

#
# This repo is managed by "percona-release" utility, do not edit!
#
[pxb-24-release-x86_64]
name = Percona XtraBackup 2.4 release/x86_64 YUM repository
baseurl = http://repo.percona.com/pxb-24/yum/release/$releasever/RPMS/x86_64
enabled = 1
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY

[pxb-24-release-sources]
name = Percona XtraBackup 2.4 release/sources YUM repository
baseurl = http://repo.percona.com/pxb-24/yum/release/$releasever/SRPMS
enabled = 0
gpgcheck = 1
gpgkey = file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
1 Like
6

Everything looks good as far as I can tell. Can you try installing it manually by getting the rpm from Download Percona Server for MySQL 5.7 ?

1 Like
9 
yum install https://downloads.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.38-41/binary/redhat/8/x86_64/Percona-Server-client-57-5.7.38-41.1.el8.x86_64.rpm
Last metadata expiration check: 0:31:33 ago on Wed 03 Aug 2022 01:27:06 PM CEST.
Percona-Server-client-57-5.7.38-41.1.el8.x86_64.rpm                                                                                         5.6 MB/s | 7.3 MB     00:01
Dependencies resolved.
============================================================================================================================================================================
 Package                                            Architecture                     Version                                   Repository                              Size
============================================================================================================================================================================
Installing:
 Percona-Server-client-57                           x86_64                           5.7.38-41.1.el8                           @commandline                           7.3 M

Transaction Summary
============================================================================================================================================================================
Install  1 Package

Total size: 7.3 M
Installed size: 37 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                    1/1
  Installing       : Percona-Server-client-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
  Running scriptlet: Percona-Server-client-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
  Verifying        : Percona-Server-client-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1

Installed:
  Percona-Server-client-57-5.7.38-41.1.el8.x86_64

Complete!



yum install https://downloads.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.38-41/binary/redhat/8/x86_64/Percona-Server-shared-57-5.7.38-41.1.el8.x86_64.rpm
Last metadata expiration check: 0:29:05 ago on Wed 03 Aug 2022 01:27:06 PM CEST.
Percona-Server-shared-57-5.7.38-41.1.el8.x86_64.rpm                                                                                         924 kB/s | 776 kB     00:00
Dependencies resolved.
============================================================================================================================================================================
 Package                                               Architecture                 Version                                Repository                                  Size
============================================================================================================================================================================
Installing:
 Percona-Server-shared-57                              x86_64                       5.7.38-41.1.el8                        @commandline                               776 k
Installing dependencies:
 Percona-Server-shared-compat-57                       x86_64                       5.7.38-41.1.el8                        ps-57-release-x86_64                       1.2 M
 compat-openssl10                                      x86_64                       1:1.0.2o-4.el8_6                       appstream                                  1.1 M

Transaction Summary
============================================================================================================================================================================
Install  3 Packages

Total size: 3.1 M
Total download size: 2.4 M
Installed size: 14 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): Percona-Server-shared-compat-57-5.7.38-41.1.el8.x86_64.rpm                                                                           7.9 MB/s | 1.2 MB     00:00
(2/2): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm                                                                                           6.2 MB/s | 1.1 MB     00:00
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                       3.3 MB/s | 2.4 MB     00:00
Percona Server 5.7 release/x86_64 YUM repository                                                                                            4.5 MB/s | 4.7 kB     00:00
Importing GPG key 0x8507EFA5:
 Userid     : "Percona Development Team (Packaging key) <info@percona.com>"
 Fingerprint: 4D1B B29D 63D9 8E42 2B21 13B1 9334 A25F 8507 EFA5
 From       : /etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                    1/1
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                           1/3
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                           1/3
  Installing       : Percona-Server-shared-compat-57-5.7.38-41.1.el8.x86_64                                                                                             2/3
  Running scriptlet: Percona-Server-shared-compat-57-5.7.38-41.1.el8.x86_64                                                                                             2/3
  Installing       : Percona-Server-shared-57-5.7.38-41.1.el8.x86_64                                                                                                    3/3
  Running scriptlet: Percona-Server-shared-57-5.7.38-41.1.el8.x86_64                                                                                                    3/3
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                           1/3
  Verifying        : Percona-Server-shared-compat-57-5.7.38-41.1.el8.x86_64                                                                                             2/3
  Verifying        : Percona-Server-shared-57-5.7.38-41.1.el8.x86_64                                                                                                    3/3

Installed:
  Percona-Server-shared-57-5.7.38-41.1.el8.x86_64          Percona-Server-shared-compat-57-5.7.38-41.1.el8.x86_64          compat-openssl10-1:1.0.2o-4.el8_6.x86_64

Complete!


yum install https://downloads.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.38-41/binary/redhat/8/x86_64/Percona-Server-server-57-5.7.38-41.1.el8.x86_64.rpm
Last metadata expiration check: 0:31:41 ago on Wed 03 Aug 2022 01:27:06 PM CEST.
Percona-Server-server-57-5.7.38-41.1.el8.x86_64.rpm                                                                                          13 MB/s |  30 MB     00:02
Dependencies resolved.
============================================================================================================================================================================
 Package                                            Architecture                     Version                                   Repository                              Size
============================================================================================================================================================================
Installing:
 Percona-Server-server-57                           x86_64                           5.7.38-41.1.el8                           @commandline                            30 M

Transaction Summary
============================================================================================================================================================================
Install  1 Package

Total size: 30 M
Installed size: 149 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Running scriptlet: Percona-Server-server-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
  Preparing        :                                                                                                                                                    1/1
  Running scriptlet: Percona-Server-server-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
  Installing       : Percona-Server-server-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
  Running scriptlet: Percona-Server-server-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details

[/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.

  Verifying        : Percona-Server-server-57-5.7.38-41.1.el8.x86_64                                                                                                    1/1

Installed:
  Percona-Server-server-57-5.7.38-41.1.el8.x86_64

Complete!
1 Like
10

@Ivan_Groenewold so?.. i need to use yum from repo not manually because is an automate process using ansible

1 Like
11

This must be something particular to Alma linux as the steps work fine in RHEL/Centos. I suggest you open an issue in jira.percona.com so the dev team can take a look

1 Like
12

ok thanks for all help. i’ll open an issue.

1 Like
13

@baph0m3t Before you open a JIRA, realize that AlmaLinux is not a supported platform and thus we provide no guarantees it will work. Switch to a supported OS for best compatibility with our documentation/steps/software.

2 Likes
14

Hi, @matthewb, thanks for the link, I’ll read it now,
meanwhile before you answer, unfortunately i did the issue in jira (sorry) in any case.
after installing manually the package I ran the role in ansible again and everything going fine. setting all i used and needs. I think in this case have to modify some task for almalinux.
thanks for the support.

2 Likes