Percona XtraBackup 2.4(EOL)

Percona XtraBackup 2.4.29 is the final release of the Percona XtraBackup 2.4 series.
Percona XtraBackup 2.4 does not support making backups of databases created in MySQL 8.0 or higher.

Full Backup

# 备份
mkdir -p /xtarbackup/full
innobackupex --user=root --password='welcome' /xtarbackup/full

# 停止MySQL服务，删除数据
systemctl stop mysqld
rm -rf /var/lib/mysql/*
rm -rf /var/log/mysqld.log
rm -rf /var/log/mysql-slow/slow.log

# 备份还原
innobackupex --apply-log /xtarbackup/full/2022-01-01_00-00-00

innobackupex --copy-back /xtarbackup/full/2022-01-01_00-00-00 /var/lib/mysql

chown -R mysql.mysql /var/lib/mysql
systemctl start mysqld

Incremental Backup

# 增量备份
innobackupex --user=root --password='welcome' /xtarbackup/full

innobackupex --user=root --password='welcome' \
--incremental /xtarbackup/incr/ \
--incremental-basedir=/xtarbackup/full/2022-01-01_00-00-00/

innobackupex --user=root --password='welcome' \
--incremental /xtarbackup/incr/ \
--incremental-basedir=/xtarbackup/incr/2022-01-02_00-00-00/

# 停止MySQL服务，删除数据
systemctl stop mysqld
rm -rf /var/lib/mysql/*
rm -rf /var/log/mysqld.log
rm -rf /var/log/mysql-slow/slow.log

# 备份还原
innobackupex --apply-log --redo-only /xtarbackup/full/2022-01-01_00-00-00/

innobackupex --apply-log --redo-only /xtarbackup/full/2022-01-01_00-00-00/ \
--increment-dir=/xtarbackup/incr/2022-01-02_00-00-00

innobackupex --apply-log --redo-only /xtarbackup/full/2022-01-01_00-00-00/ \
--increment-dir=/xtarbackup/incr/2022-01-03_00-00-00

innobackupex --copy-back /xtarbackup/full/2022-01-01_00-00-00 /var/lib/mysql

chown -R mysql.mysql /var/lib/mysql
systemctl start mysqld