1

Percona-Cluster: backup and restore procedure

view story
linux-howto

http://serverfault.com – I'm trying to restore a full backup taken from one node of a three-node percona cluster (percona cluster 5.5, galera 2.1, wsrep sst method is rsync, innodb tables only). Backup was taken like this: rm -rf /tmp/backup/mysqldb innobackupex --user=bkpuser --password=xxxx --galera-info --no-timestamp /tmp/backup/mysqldb/ innobackupex --apply-log --use-memory=2G /tmp/backup/mysqldb/ The restore procedure I'm attempting is like this: shut down mysql on all three nodes on first node delete contents of mysql data dir delete mysql redologs/binlogs, doublewrite file etc (they are located in a sep (HowTos)