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

8.0 - --galera-info --no-backup-locks does not create xtrabackup_galera_info

aalba6675aalba6675 EntrantCurrent User Role Supporter
edited November 11 in Percona XtraBackup


  1. Is innobackupex deprecated for 8.0?
  2. Doing xtrabackup with --galera-info --no-backup-locks does not create the xtrabackup_galera_info file.

Bigger question: is manual SST viable? I.e. create a backup on DONOR


xtrabackup --backup --galera-info --no-backup-locks

# assuming this works, but I couldn't find xtrabackup_galera_info...

Transfer backup directory to putative JOINER, prep, copy-back then attempt to join cluster.


MariaDB still has a manual SST article, but I didn't find anything similar for PXC.

Best Answer

  • Marcelo AltmannMarcelo Altmann Percona Staff Role
    Accepted Answer
    1. Yes, innobackupex has been deprecated on 2.4 and completely removed on 8.0
    2. That is still possible. File is created at --prepare phase:

    [[email protected] ~]# cat /tmp/backup/xtrabackup_info | grep version

    tool_version = 8.0.13

    ibbackup_version = 8.0.13

    server_version = 8.0.20-11.3

    [[email protected] ~]# cat /tmp/backup/xtrabackup_galera_info

    0fb0c479-2422-11eb-bb57-23a730de0c57:10

Answers

  • aalba6675aalba6675 Entrant Current User Role Supporter

    Thank you! Can I confirm that --no-backup-locks is needed for --galera-info/manual SST to work?

  • Marcelo AltmannMarcelo Altmann Percona Staff Role

    You don't need --no-backup-locks for it to work. However, I would advise you to use --lock-ddl to block DDLs while taking the backup.

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.