您好,登錄后才能下訂單哦!
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、恢復(fù)過程
??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一個(gè)類似工具
4、準(zhǔn)備備份版本差異
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?"沒有l(wèi)sn信息,開始一次全備" ?????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
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。