?安裝依賴包：

wget-O/etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repoyum-y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL libev

下載軟件并安裝

wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.12/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpmhttps://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/binary/redhat/6/x86_64/percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpmyum-y install percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

innobackupex使用

[root@db01 backup]# innobackupex --user=root --password=123 -S /tmp/mysql.sock --no-timestamp /backup/full

innobackupex --apply-log /backup/full? 追平lsn號? 模擬csr的過程

cat xtrabackup_binlog_info

mysql-bin.000007? ? ? ? 194? ? 5b65d91d-5bb1-11ea-b30e-000c291bec8a:1-8

記錄二級制信息

重啟數(shù)據(jù)庫會刷新一個新的二級制日志

cat xtrabackup_checkpoints

差九個數(shù)說明沒有增量

增量備份：

--incremental? 開關(guān)

--incremental-basedir=/backup/full? 基于full進(jìn)行增量

innobackupex --user=root --password=123 -S /tmp/mysql.sock --no-timestamp --incremental --incremental-basedir=/backup/full /backup/new

備份恢復(fù)加增量加binlog：

innobackupex--apply-log--redo-only /backup/full? ?

合并?innobackupex --apply-log --redo-only --incremental-dir=/backup/new /backup/full

最后整理

innobackupex --apply-log /backup/full

截取二進(jìn)制

起點：cat /backup/inc2/xtrabackup_binlog_info

終點：mysqlbinlog /data/binlog/mysql-bin.000008 |grep 'SET'

mysqlbinlog--skip-gtids--include-gtids='1afe8136-601d-11e9-9022-000c2928f5dd:7-9'/data/binlog/mysql-bin.000009>/data/backup/binlog.sql

cp-a*/data/mysql/data2

chown-R mysql./data/*

systemctl stop mysqld

vim /etc/my.cnf

datadir=/data/mysql/data2

systemctl start mysqld

Master [(none)]>set sql_log_bin=0;

Master [(none)]>source /data/backup/binlog.sql