xtrabackup遠(yuǎn)程流備份腳本

1、xbstream 流，本地文件夾可以自己創(chuàng)建，異地文件夾必須存在

十多年的延慶網(wǎng)站建設(shè)經(jīng)驗(yàn)，針對設(shè)計(jì)、前端、開發(fā)、售后、文案、推廣等六對一服務(wù)，響應(yīng)快，48小時(shí)及時(shí)工作處理。全網(wǎng)整合營銷推廣的優(yōu)勢是能夠根據(jù)用戶設(shè)備顯示端的尺寸不同，自動(dòng)調(diào)整延慶建站的顯示方式，使網(wǎng)站能夠適用不同顯示終端，在瀏覽器中調(diào)整網(wǎng)站的寬度，無論在任何一種瀏覽器上瀏覽網(wǎng)站，都能展現(xiàn)優(yōu)雅布局與設(shè)計(jì)，從而大程度地提升瀏覽體驗(yàn)。創(chuàng)新互聯(lián)公司從事“延慶網(wǎng)站設(shè)計(jì)”,“延慶網(wǎng)站推廣”以來，每個(gè)客戶項(xiàng)目都認(rèn)真落實(shí)執(zhí)行。

?innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--compress?/root/backup/?|?ssh?root@192.168.56.15?"xbstream?-x?-C?/tmp/"

2、xbstream 流，對端機(jī)器需要解壓并清理壓縮文件

192.168.56.15
xtrabackup?--decompress?--target-dir=/tmp/
find?/tmp/?-name?"*.qp"?|xargs??rm?-f

3、xbstream 流對端需要安裝軟件

3.1 xtrabackup

3.2 qpress-11-linux-x64.tar

4、腳本，周一全備，其它都是增備

[root@es1?chkpoint]#?cat?backup.sh
#!/bin/bash

LOCALDIR=/data/backup
CHECKPIONTDIR=$LOCALDIR/chkpoint
REMOTEDIR=/tmp/


WEEKDAY=`date?+%u`
INTERVARNUM=`expr?$WEEKDAY?-?1`
TISHWEEKFULL=`date?-d?"$INTERVARNUM?day?ago"?+%F`
TODAY=`date?+%F`

ssh?root@192.168.56.19?"mkdir?-p?/$REMOTEDIR/$TISHWEEKFULL"
ssh?root@192.168.56.19?"mkdir?-p?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"


if?[?!?-f?$CHECKPIONTDIR/xtrabackup_checkpoints?]?;then

echo?"沒有l(wèi)sn信息，開始一次全備"

innobackupex?--host=127.0.0.1?--history??--post=3306?--stream=xbstream???--compress?--extra-lsndir=$CHECKPIONTDIR??$LOCALDIR?|ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/"
exit?1
fi


case?$WEEKDAY?in
#判斷變量WEEKDAY的值
????"1")

????innobackupex?--host=127.0.0.1?--history??--post=3306?--stream=xbstream???--compress?--extra-lsndir=$CHECKPIONTDIR??$LOCALDIR?|ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/"????????;;
????"2")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;
????????"3")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;
????"4")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;
????????"5")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;
????????"3")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;
????"4")

???????innobackupex?--host=127.0.0.1??--post=3306?--stream=xbstream??--history?????--incremental?--extra-lsndir=$CHECKPIONTDIR??--incremental-basedir=$CHECKPIONTDIR???--compress?$LOCALDIR?|?ssh?root@192.168.56.19?"xbstream?-x?-C?/$REMOTEDIR/$TISHWEEKFULL/$TODAY"

????????;;

esac

5、tar 目前不支持增備，壓縮解壓需要注意，需要tar -xizvf? *.tar.gz

網(wǎng)頁標(biāo)題：xtrabackup遠(yuǎn)程流備份腳本
本文地址：http://bm7419.com/article46/igcieg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供虛擬主機(jī)、手機(jī)網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計(jì)公司、ChatGPT、用戶體驗(yàn)、做網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

成都網(wǎng)站建設(shè)