安装

通过apt安装，比较省事

debian上先安装源，再通过apt安装debian上先安装源，再通过apt安装。

https://docs.percona.com/percona-xtrabackup/2.4/installation/apt_repo.html

直接下载tar.gz安装包

全备份

机器A上执行

xtrabackup --defaults-file=/usr/local/mysql/mysql-5.7.26-linux-glibc2.12-x86_64/etc/my.cnf  --backup --target-dir=/root/xtrabackup/full-backup --user=root --host=127.0.0.1 --port=38

增量备份

机器A上执行

xtrabackup --defaults-file=/usr/local/mysql/mysql-5.7.26-linux-glibc2.12-x86_64/etc/my.cnf  --backup --target-dir=/root/xtrabackup/inc-backup1  --incremental-basedir=/root/xtrabackup/full-backup  --user=root --host=127.0.0.1 --port=3001

全恢复

机器B上执行

/mast/packageLinux/xtrabackup/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin/xtrabackup  --prepare --target-dir=/mast/vps_xtrabackup/full-backup/

/mast/packageLinux/xtrabackup/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin/xtrabackup  --defaults-file=/mast/opt/mysql-5.7.26-linux-glibc2.12-x86_64/etc/my.cnf  --copy-back --target-dir=/mast/vps_xtrabackup/full-backup/

增量恢复

https://docs.percona.com/percona-xtrabackup/2.4/backup_scenarios/incremental_backup.html
https://github.com/icyhearts/pxb-docs/blob/2.4/docs/backup_scenarios/incremental_backup.md

prepare

/mast/packageLinux/xtrabackup/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin/xtrabackup  --prepare --apply-log-only --target-dir=/mast/vps_xtrabackup/xtrabackup/full-backup/
/mast/packageLinux/xtrabackup/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin/xtrabackup  --prepare --apply-log-only --target-dir=/mast/vps_xtrabackup/xtrabackup/full-backup/ --incremental-dir=/mast/vps_xtrabackup/xtrabackup/inc-backup1/

copy-back

copy前注意chown一下目录

/mast/packageLinux/xtrabackup/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin/xtrabackup  --defaults-file=/mast/opt/mysql-5.7.26-linux-glibc2.12-x86_64/etc/my.cnf  --copy-back --target-dir=/mast/vps_xtrabackup/xtrabackup/full-backup/

copy后再把目录chown成mysql