Not the answer you need?
Register and ask your own question!

Confusion about Xtrabackup Versions

jjostjjost EntrantCurrent User Role Beginner
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

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

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

    [email protected]:~/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*
    [email protected]:~/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."
    http://www.percona.com/doc/percona-xtrabackup/2.2/

    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.
  • jjostjjost Entrant Current User Role Beginner
    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.
  • lbug7575lbug7575 Entrant Legacy User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.