###8.0只支持mysql 8.0 其他版本需要2.x去支持
--install step
wget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_64/dag/RPMS/libev-4.15-1.el6.rf.x86_64.rpm
yum install perl* -y
rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm
yum localinstall percona-xtrabackup-80-8.0.9-1.el7.x86_64.rpm
CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY '199146';
grant all ON *.* TO 'bkpuser'@'localhost';
FLUSH PRIVILEGES;
GRANT BACKUP_ADMIN,PROCESS,RELOAD,LOCK TABLES,REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';
GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';
FLUSH PRIVILEGES;
1.全量备份
xtrabackup --user=bkpuser --password=199146 --backup --target-dir=/data/5.7/backup --datadir=/data/5.7/3306 --socket=/data/5.7/3306/mysql.sock
xtrabackup --prepare --target-dir=/data/5.7/backup
xtrabackup --copy-back --target-dir=/data/5.7/backup --datadir=/data/5.7/3306 --socket=/data/5.7/3306/mysql.sock
2.增量备份
一.backup
xtrabackup --backup --target-dir=/data/backups/base --datadir=/var/lib/mysql/
If you look at the file, you should see contents similar to the following:
backup_type = full-backuped
from_lsn = 0
to_lsn = 1291135
xtrabackup --backup --target-dir=/data/backups/inc1 \
--incremental-basedir=/data/backups/base --datadir=/var/lib/mysql/
xtrabackup_checkpoints
backup_type = incremental
from_lsn = 1291135
to_lsn = 1291340
xtrabackup --backup --target-dir=/data/backups/inc2 \
--incremental-basedir=/data/backups/inc1 --datadir=/var/lib/mysql/
/data/backups/base
/data/backups/inc1
/data/backups/inc2
二. prepare and restore
##--apply-log-only --apply-log-only should be used when merging all incrementals except the last one.
xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base
xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base \
--incremental-dir=/data/backups/inc1
xtrabackup --prepare --target-dir=/data/backups/base \
--incremental-dir=/data/backups/inc2
restore
xtrabackup --copy-back --target-dir=BASE-DIR
