準(zhǔn)備工作

CREATE USER 'bakuser'@'localhost' IDENTIFIED BY 's3cret';

GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO

? ? ? 'bakuser'@'localhost';

FLUSH PRIVILEGES;

安裝

一、全量備份

1、create user backup@localhost identified by '1qaz!QAZ';

2、GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'backup'@'localhost';

3、FLUSH?PRIVILEGES;

4、執(zhí)行備份命令

xtrabackup --user=root --password=123456 --backup --datadir=/data/mysql/data/ --target-dir=/data/backups/mysql/ --host=127.0.0.1

二、恢復(fù)

1、先停止數(shù)據(jù)庫，把之前的數(shù)據(jù)目錄清空或者備份好，執(zhí)行一下數(shù)據(jù)恢復(fù)命令

? ? ? ?xtrabackup --prepare --target-dir=/data/backups/mysql

? ? ? ?xtrabackup?--move-back?--target-dir=/data/backups/mysql?--datadir=/data/mysql/data/

三、增量備份

1、先進(jìn)行一次全量備份

xtrabackup --user=root --password=123456 --backup --datadir=/data/mysql/data/ --target-dir=/data/backups/mysql/ --host=127.0.0.1

2、進(jìn)行第一次增量備份

xtrabackup --backup --target-dir=/data/backups/mysql/inc1 --incremental-basedir=/data/backups/mysql??--datadir=/data/mysql/data/??--host=127.0.0.1

3、進(jìn)行第二個(gè)次增量備份

xtrabackup --backup --target-dir=/data/backups/mysql/inc2 --incremental-basedir=/data/backups/mysql/inc1?--datadir=/data/mysql/data/??--host=127.0.0.1

四、恢復(fù)

1、全量恢復(fù)

? ? ?xtrabackup --prepare --apply-log-only --target-dir=/data/backups/mysql

2、第一次增量備份恢復(fù)

? ??xtrabackup --prepare --apply-log-only --target-dir=/data/backups/mysql --incremental-dir=/data/backups/mysql/inc1

3、第二次增量備份恢復(fù)

?xtrabackup --prepare --apply-log-only --target-dir=/data/backups/mysql --incremental-dir=/data/backups/mysql/inc2

4、進(jìn)行數(shù)據(jù)恢復(fù)

xtrabackup?--move-back?--target-dir=/data/backups/mysql?--datadir=/data/mysql/data/