Confusion about Xtrabackup Versions

MySQL & MariaDB Percona XtraBackup
1

Hi!,

I am running an 5 Head Percona XtraDB-Cluster 5.5.39-36.0-55-log.

Xtrabackup Version installed is
percona-xtrabackup-2.2.8

I found in my logs that the xtrabackup is starting a wrong version of innodb:
xtrabackup version 2.2.8 based on MySQL server 5.6.22

I remember that it is important to use the “right” binary of xtrabackup for the Server. In the xtrabackup version percona-xtrabackup-2.1.9 where 3 binarys and the log said:
xtrabackup_55 version 2.1.9 for Percona Server 5.5.35

I am a little bit concerned that the 5.6 innodb is possibly writing unreadable datafiles for 5.5 innodb.

Can somebody explain this to me?

Greetz
Julian

2

Hi,

In the earlier version like 2.0 and 2.1, there were multiple binaries as per the mysql versions. i.e

nilnandan@desktop:~/Downloads/percona-xtrabackup-2.0.8/bin$ ll
total 118940
drwxr-xr-x 2 nilnandan nilnandan 4096 Sep 3 2013 ./
drwxr-xr-x 4 nilnandan nilnandan 4096 Sep 3 2013 …/
-rwxr-xr-x 1 nilnandan nilnandan 113912 Sep 3 2013 innobackupex*
lrwxrwxrwx 1 nilnandan nilnandan 12 Sep 3 2013 innobackupex-1.5.1 → innobackupex*
-rwxr-xr-x 1 nilnandan nilnandan 2258560 Sep 3 2013 xbstream*
-rwxr-xr-x 1 nilnandan nilnandan 12557890 Sep 3 2013 xtrabackup*
-rwxr-xr-x 1 nilnandan nilnandan 10667223 Sep 3 2013 xtrabackup_51*
-rwxr-xr-x 1 nilnandan nilnandan 15720860 Sep 3 2013 xtrabackup_55*
-rwxr-xr-x 1 nilnandan nilnandan 80404343 Sep 3 2013 xtrabackup_56*
nilnandan@desktop:~/Downloads/percona-xtrabackup-2.0.8/bin$

But from the 2.2 version, there are no separate binaries and as per the doc for single binary, “It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1 [other than builtin 5.1 InnoDB], 5.5 and 5.6 servers, as well as Percona Server with XtraDB.”
[url]Percona XtraBackup

So I don’t think it should create any issue. Still, I would suggest you to take backup, prepare and try to use it and let us know if you face any issue.

3

Hi,

Thank you for your answer. So I can ignore the messages telling me about the MySQL Version.
Actually I have a problem with SST since Updating to the new xtrabackup version. This might be related, but I wanted to expulse that this is related. Iam taking Backups every hour und instantly testing them every hour. But i feared xtrabackup might create Files that are not readable somewhere for a MySQL 5.5 Server.

4

Percona Xtrabackup one is system user and other is database user and it’s not necessary to have root access for that.

http://solitairechamp.biz