innobackup的全备和打包脚本-创新互联

改几个变量就可以用了， innobackup的全备和打包脚本

[root@Pro-aliyun-MySQL-transit-10.25.34.225 ~]# cat full.sh 

#!/bin/bash

# centos 7.6 x86_64

# mysql 5.7.26-log

# 2019.9.16

# Version 2.4 begins to support 5.7

# https://www.percona.com/downloads/XtraBackup/

# wget -c https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.9/binary/redhat/6/x86_64/percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm --no-check-certificate

# yum -y localinstall percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm

a=`date +%s`

yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL libev-devel

LOCALIP=$(hostname -i)

MYCNF=/owhat/mysql-5.7

HOST=localhost

USER=root

PASS=amunlinux

PORT=65306

SOCK=/owhat/mysql-5.7/logs/mysql.sock

DATA=/owhat/download-data

DATE=$(date +%Y-%m-%d)

touch ~/full-record-"$LOCALIP".log

> ~/full-record-"$LOCALIP".log

which innobackupex >> ~/full-record-"$LOCALIP".log

#/usr/bin/innobackupex   \

#--defaults-file="$MYFILEDIR"  \

#--user="$USER"  \

#--port="$PORT"  \

#--host="$HOST"  \

#--password="$PASS"  \

#--parallel=32  \

#-S "$SOCK"  \

#--no-timestamp "$DATA"/"$DATE" >>  ~/full-record-"$LOCALIP".log

sleep 3s

# <= 50G

tar -zcvP -f  ~/AliyunMySQL-$LOCALIP-$DATE.tar.gz "$DATA"/"$DATE" >> ~/full-record-"$LOCALIP".log

sleep 3s

b=`date +%s`

c=`expr $b - $a`

echo "A total of time $c s" >> ~/full-record-"$LOCALIP".log

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。