I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is:

innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)

But I am using MySQL 5.5. Is this the correct version of innobackupex to use with my databases, and if not which version should I use? The documentation isn't very clear.

I installed it using the following process:

apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

sudo pico /etc/apt/sources.list

then add the following two lines
    deb http://repo.percona.com/apt jessie main
    deb-src http://repo.percona.com/apt jessie main

apt-get update

apt-get install percona-xtrabackup
  • Does it work without error? If so... – Philᵀᴹ Oct 26 '16 at 15:22
  • initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version. – IGGt Oct 26 '16 at 15:47
  • percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6 – Philᵀᴹ Oct 26 '16 at 16:05
  • So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4? – IGGt Oct 27 '16 at 7:46

Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.

PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.

In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.