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?
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?
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)
Btw, for PXC we bundle PXB inside /usr/bin/pxc_extra/pxb-8.0/bin/xtrabackup
@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.
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?
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.
@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
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)
@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?