xtrabackup故障演练

#搭建基础环境

mysql> source /scripts/xtrabackup/add_user.sql;

#第一次全量备份

[root@MHA-Master-201 mysql-backup]#innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1  --user=xtrabackup --password=123456  --use-memory=2G  /data/mysql-backup/full

210119 08:59:56 Backup created in directory '/data/mysql-backup/full/2021-01-19_08-59-49/'

#第一次增量备份

[root@MHA-Master-201 mysql-backup]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1  --user=xtrabackup --password=123456 --no-lock --use-memory=2G   --incremental /data/mysql-backup/inc/ --incremental-basedir=/data/mysql-backup/full/2021-01-19_08-59-49/

210119 09:02:53 Backup created in directory '/data/mysql-backup/inc/2021-01-19_09-02-43/'

#删库

mysql> drop database test;

Query OK, 1 row affected (0.25 sec)

#第二次增量备份

[root@MHA-Master-201 mysql-backup]# innobackupex --defaults-file=/etc/my.cnf --host=127.0.0.1  --user=xtrabackup --password=123456 --no-lock --use-memory=2G   --incremental /data/mysql-backup/inc/ --incremental-basedir=/data/mysql-backup/inc/2021-01-19_08-36-50/

210119 08:40:10 Backup created in directory '/data/mysql-backup/inc/2021-01-19_08-40-01/'

#开始恢复

#首先恢复第一个全量备份

apply-log

[root@MHA-Master-201 mysql-backup]# innobackupex --apply-log-only --redo-only /data/mysql-backup/full/2021-01-19_08-59-49/'