Percona Xtrabackup version compatibility with MySQL 8.0

MySQL & MariaDB Percona XtraBackup
1

We have MySQL 8 installed PXC 8.0.27-18.1.el7 but Xtrabackup version 8.0.26-18.1.el7 installed. We tried to do a backup and said this…

Error: Unsupported server version 8.0.27-18.1.

Please upgrade PXB, if a new version is available

Is my current version of Xtrabackup not going to work with Current PXC??? Why?
I noticed if I need to install a newer version of PXB it has to be 8.0.27-19.1.el7 as that is all I am able to see. Can someone let me know what I need to do here?

Thank you!

1 Like
2

Hi @jasonfe33 ,

The current version of PXB is 8.0.28, for PXC 8.0.27 you should use PXB 8.0.27 .

How are you installing PXC? via yum?

1 Like
3

I just did a quick install of PXC on centos7 and everything looks ok.

[root@198cd92bb429 /]# mysqld --version
/usr/sbin/mysqld  Ver 8.0.27-18.1 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel18, Revision ac35177, WSREP version 26.4.3)
[root@198cd92bb429 /]# /usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup --version
xtrabackup: recognized server arguments: --server-id=1 --datadir=/var/lib/mysql
/usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda)
[root@198cd92bb429 /]#

Btw, for PXC we bundle PXB inside /usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup

1 Like
4

@Marcelo_Altmann Hello there, thank you so much for the quick responses! when I checked to see what xtrabackup was installed I did a “yum list installed” and it showed the old 24 version. So, I presumed xtrabackup wasn’t updated to 8.0. Then I ran below commands per support.

wget https://downloads.percona.com/downloads/Percona-XtraBackup-LATEST/Percona-XtraBackup-8.0.26-18/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.26-18.1.el7.x86_64.rpm

uninstall current percona xtrabackup
rpm -e percona-xtrabackup-24-2.4.24-1.el7.x86_64

run install for new percona xtrabackup
rpm -i percona-xtrabackup-80-8.0.26-18.1.el7.x86_64.rpm

But our developer is saying that 8.0.27 was already installed and I installed 8.0.26 over it? If he runs ```
/usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup --version it shows 27 he says.

So now, we are wondering how to clean this up. Probably uninstall Xtrabackup 8.0.26 and then update Xtrabackup using yum?

1 Like
5

@jasonfe33,
When you install the PXC packages, you automatically get xtrabackup installed. There is no need to install it again. This path, /usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup is the version of xtrabackup that is automatically included. If you installed xtrabackup 8.0.26 via RPM, then that binary will be located somewhere else (probably /usr/bin/xtrabackup). Run rpm -qa percona-xtrabackup-80-8.0.26-18 to see the locations of all files installed by that package.

1 Like
6

@matthewb Hey Matthew. So I think he uninstalled the RPM I installed for 8.0.26 and ran update for xtrabackup using yum and I think it updated xtrabackup to 28. So here is what it shows now. Is this looking fine for installed Percona? Xtrabackup should work as it is now? I got this by doing a “Yum list installed”

percona-release.noarch 1.0-27 @percona-release-x86_64
percona-toolkit.noarch 2.2.19-1 @percona-release-noarch
percona-xtrabackup-80.x86_64 8.0.28-20.1.el7 @percona-release-x86_64
percona-xtradb-cluster.x86_64 8.0.27-18.1.el7 @pxc-80-release-x86_64
percona-xtradb-cluster-client.x86_64 8.0.27-18.1.el7 @pxc-80-release-x86_64
percona-xtradb-cluster-server.x86_64 8.0.27-18.1.el7 @pxc-80-release-x86_64
percona-xtradb-cluster-shared.x86_64 8.0.27-18.1.el7 @pxc-80-release-x86_64
percona-xtradb-cluster-shared-compat.x86_64
8.0.27-18.1.el7 @pxc-80-release-x86_64

1 Like
7

Yep, that is all fine. All the same version for PXC 8.0.27, and xtrabackup 8.0.28 (which is fine to use on 8.0.27)

1 Like
8

@matthewb Nice. is xtrabackup 8.0.28 ok to use on PXC 8.0.26? I presume xtrabackup can be higher but it can’t be below version?

1 Like
9

can be higher but it can’t be below version

Correct.

1 Like