Problem: percona-xtrabackup installation fails on CentOS and version 8.0

[mamedin]

Ansible error in new deploy:

fatal: [template-cluster-mysql]: FAILED! => {"changed": false, "msg": "No package matching 'percona-xtrabackup' found available, installed or updated", "rc": 126, "results": ["No package matching 'percona-xtrabackup' found available, installed or updated"]}

Looking at server:

[root@mamedin-template-cluster-2 ~]# sudo yum search percona-xtrabackup
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.dst.ca
 * extras: centos-canada.altinsoft.net
 * updates: centos-canada.vdssunucu.com.tr
============================================================================================================================ N/S matched: percona-xtrabackup =============================================================================================================================
percona-xtrabackup-24-debuginfo.x86_64 : Debug information for package percona-xtrabackup-24
percona-xtrabackup-80-debuginfo.x86_64 : Debug information for package percona-xtrabackup-80
percona-xtrabackup-24.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-80.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-test-24.x86_64 : Test suite for Percona XtraBackup
percona-xtrabackup-test-80.x86_64 : Test suite for Percona XtraBackup

The role is trying to install percona-xtrabackup but it doesn't exist.

Weird error because I used the same config 3 days ago and it worked on CentOS (new deployment too).

[mamedin]

Using "percona-xtrabackup-{{mysql_version_major}}{{mysql_version_minor}}" instead of "percona-xtrabackup" in tasks/install-centos.yml fixes the issue.

[mamedin]

Trying again the same deploy (deleting the test VM), the percona-xtrabackup package appears:

[root@mamedin-template-cluster-2 ~]# yum search percona-xtrabackup
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos-canada.vdssunucu.com.tr
 * epel: mirror.dst.ca
 * extras: mirror.dst.ca
 * updates: centos-canada.vdssunucu.com.tr
============================================================================================================================ N/S matched: percona-xtrabackup =============================================================================================================================
percona-xtrabackup-24-debuginfo.x86_64 : Debug information for package percona-xtrabackup-24
percona-xtrabackup-80-debuginfo.x86_64 : Debug information for package percona-xtrabackup-80
percona-xtrabackup.x86_64 : Online backup for InnoDB/XtraDB in MySQL, Percona Server and MariaDB
percona-xtrabackup-24.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-80.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-test.x86_64 : Test suite for Percona Xtrabackup
percona-xtrabackup-test-24.x86_64 : Test suite for Percona XtraBackup
percona-xtrabackup-test-80.x86_64 : Test suite for Percona XtraBackup

  Name and summary matches only, use "search all" for everything.

[mamedin]

Makes sense because this package comes from epel repository:

[root@mamedin-template-cluster-2 ~]# repoquery -i percona-xtrabackup

Name        : percona-xtrabackup
Version     : 2.3.6
Release     : 1.el7
Architecture: x86_64
Size        : 19159778
Packager    : Fedora Project
Group       : Unspecified
URL         : http://www.percona.com/software/percona-xtrabackup/
Repository  : epel
Summary     : Online backup for InnoDB/XtraDB in MySQL, Percona Server and MariaDB
Source      : percona-xtrabackup-2.3.6-1.el7.src.rpm
Description :
Online backup for InnoDB/XtraDB in MySQL, MariaDB and Percona Server.

The repoquery output for percona-xtrabackup-80:

[root@mamedin-template-cluster-2 ~]# repoquery -i percona-xtrabackup-80

Name        : percona-xtrabackup-80
Version     : 8.0.23
Release     : 16.1.el7
Architecture: x86_64
Size        : 13637940
Packager    : None
Group       : Applications/Databases
URL         : http://www.percona.com/software/percona-xtrabackup
Repository  : tools-release-x86_64
Summary     : XtraBackup online backup for MySQL / InnoDB
Source      : percona-xtrabackup-80-8.0.23-16.1.el7.src.rpm
Description :
Percona XtraBackup is OpenSource online (non-blockable) backup solution for InnoDB and XtraDB engines

[mamedin]

Checking Ubuntu deploys, we are installing percona-xtrabackup 2.3 from percona repository:

artefactual@atomna-mysql-2:~$ sudo apt-cache policy percona-xtrabackup
percona-xtrabackup:
  Installed: (none)
  Candidate: 1:2.3.10-1.bionic
  Version table:
     1:2.3.10-1.bionic 500
        500 http://repo.percona.com/apt bionic/main amd64 Packages
     2.4.9-0ubuntu2 500
        500 http://nova.clouds.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages

So probably the best way to fix the issue is installing the Epel repo with role. The issue happens when installing a server dedicated for MySQL database with role, that's the reason because we have not seen it before. We don't have dedicated CentOS MySQL servers (dedicated).