mariabackup 增量備份還原

1、全備和增量過程命令

??mariabackup?--backup????--target-dir=/var/mariadb/backup/????--user=root?--password=
??mariabackup?--backup????--target-dir=/var/mariadb/inc1/????--incremental-basedir=/var/mariadb/backup/????--user=root?--password=
??mariabackup?--backup?--history???--target-dir=/var/mariadb/inc2/????--incremental-basedir=/var/mariadb/inc1????--user=root?--password=
??mariabackup?--backup?--history???--target-dir=/var/mariadb/inc3/????--incremental-basedir=/var/mariadb/inc2????--user=root?--password=

2、恢復過程

??mariabackup?--prepare?--target-dir=/var/mariadb/backup
??mariabackup?--prepare????--target-dir=/var/mariadb/backup????--incremental-dir=/var/mariadb/inc1
??mariabackup?--prepare????--target-dir=/var/mariadb/backup????--incremental-dir=/var/mariadb/inc2
??mariabackup?--prepare????--target-dir=/var/mariadb/backup????--incremental-dir=/var/mariadb/inc3
??/etc/init.d/mysql?stop

??mariabackup?--copy-back????--target-dir=/var/mariadb/backup/
??
??/etc/init.d/mysql?start

3、特別說明

MariaDB10.2.7以后不再支持使用Percona?XtraBackup工具在線物理熱備份，所以就自己copy一個類似工具

4、準備備份版本差異

MariaDB?starting?with?10.2?使用
mariabackup?--prepare?\
???--target-dir=/var/mariadb/backup
MariaDB?until?10.1?使用
$?mariabackup?--prepare?--apply-log-only?\
???--target-dir=/var/mariadb/backup

5、每周一次全量，其余增量腳本

#!/bin/bash

LOCALDIR=/data/mysqlbak


WEEKDAY=`date?+%u`
INTERVARNUM=`expr?$WEEKDAY?-?1`
TISHWEEKFULL=`date?-d?"$INTERVARNUM?day?ago"?+%F`
YESTERDAY=`date?-d?"1?day?ago"?+%F`
TODAY=`date?+%F`
FULL=/$LOCALDIR/$TISHWEEKFULL/full
INCR=/$LOCALDIR/$TISHWEEKFULL/incr/$TODAY
YESTERDAYDIR=/$LOCALDIR/$TISHWEEKFULL/incr/$YESTERDAY

if?[?!?-d?$FULL?]?;then

echo?"沒有lsn信息，開始一次全備"

?????mkdir?-p?$FULL
?????/usr/bin/mariabackup?--backup?--slave-info?--kill-long-queries-timeout=120?--kill-long-query-type=select??--target-dir=$FULL/

exit?0
fi

mkdir?-p?$INCR

if?[?!?-d?$YESTERDAYDIR?]??;then
?/usr/bin/mariabackup?--backup????--slave-info?--kill-long-queries-timeout=120?--kill-long-query-type=select?????????--target-dir=$INCR/??--incremental-basedir=$FULL
exit?0
fi

?/usr/bin/mariabackup?--backup????--slave-info?--kill-long-queries-timeout=120?--kill-long-query-type=select?????????--target-dir=$INCR/??--incremental-basedir=$YESTERDAYDIR