Restore backup created by innobackupex

  • Filter
  • Time
  • Show
Clear All
new posts

  • Restore backup created by innobackupex

    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?

  • #2
    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.


    • #3
      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?



      • #4
        Hi Scott,

        If you have a gcache big enough to store all the modification since the backup, galera info can be used to recreate grastate.dat.

        With the lastest version the info is also stored in InnoDB, but I don't know how is behaves, so I recommend you to follow this post :

        http://www.mysqlperformanceblog.com/2012/08/02/avoiding-sst- when-adding-new-percona-xtradb-cluster-node/

        Best regards,