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

Restore backup created by innobackupex

sah209@psu.edu[email protected] EntrantCurrent User Role Beginner
wsrep_provider_version | 2.2(r137)

Server version: 5.5.28-log Percona XtraDB Cluster (GPL), wsrep_23.7.r3821


Created a backup with innobackupex, including --galera-info

Please confirm these steps:

If I want to restore the backup,

1) shut down all nodes within the cluster

2) Restore backup
innobackupex --copy-back /path/to/BACKUP-DIR

3) check files permissions on/in data-dir (/var/lib/mysql), and change as necessary

4) modify my.cnf file parameter wsrep_cluster_address to gcomm:// to re-initialize cluster

5) restart mysql

6) start other nodes in cluster, 1 by 1 - should see SST performed

Does that sound about right?

How does the xtrabackup_galera_info file come into play?

Comments

  • lefredlefred Contributor Inactive User Role Beginner
    I you want to restore all the nodes like that, you can just ignore the galera_info, this is used to specifies the position in the replication to be able to perform IST instead of SST.
    If you want to be sure that all your server will perform the SST, you can delete the file grastate.dat (in datadirectory) before starting mysql.
  • sah209@psu.edu[email protected] Entrant Current User Role Beginner
    lefred -
    thanks for the info, however, can you explain further how to restore using the galera_info?

    Say I have a 3-node cluster, and I plan to restore to node 1. How would my steps be modified if I wanted IST for nodes 2 and 3?

    Regards,
    Scott
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.