FtpPath=/ftp/backup/mysql
mkdir -p $BackupPath
#备份mysql并导出到文件
mysqldump -u M y s q l U s e r − p MysqlUser -p MysqlUser−pMysqlPwd -h$MysqlHost --opt --all-databases -f > $FileFullPath.sql
#压缩备份文件
tar -Pzcvf $FileFullPath.tar.gz $FileFullPath.sql
#上传到ftp
ftp -n $FtpHost <<AUTOEOF
quote USER $FtpUser
quote PASS $FtpPwd
cd $FtpPath
binary
put $FileFullPath.tar.gz
F
t
p
P
a
t
h
/
FtpPath/
FtpPath/FileName.tar.gz
quit
AUTOEOF
#删除SQL文件
rm -rf $FileFullPath.sql
#删除30天之前的文件
find $BackupPath -type f -mtime +30 -exec rm -f {} ;
## 企业生产环境Shell脚本案例分享
生产环境下的Shell脚本还是挺多的，这里介绍几个企业常见的Shell脚本。
1、MySQL数据库备份脚本,下面的脚本是Mysql全量备份+异地备份
一般Mysql数据库备份会采用在MYSQL从库上执行全量备份+增量备份方式。在从库备份避免Mysql主库备份的时候锁表造成业务影响。
shell> vim db_backup.sh
#!/bin/bash
description: MySQL buckup shell script
author: magedu.com
192.168.10.10 为专门的备份服务器，需要做一下服务器之间免密码登录
#备份的数据库名
DATABASES=(
“magedu01”
“magedu02”
)
USER=“root”
PASSWORD=“dbpwd123”
MAIL=“magedu@gmail.com”
BACKUP_DIR=/data/backup
LOGFILE=/data/backup/data_backup.log
DATE=date +%Y%m%d_%H%M
cd $BACKUP_DIR
#开始备份之前，将备份信息头写入日记文件
echo “--------------------” >> $LOGFILE
echo “BACKUP DATE:” $(date +“%y-%m-%d %H:%M:%S”) >> $LOGFILE
echo “-------------------” >> $LOGFILE
for DATABASE in
D
A
T
A
B
A
S
E
S
;
d
o
/
u
s
r
/
l
o
c
a
l
/
m
y
s
q
l
/
b
i
n
/
m
y
s
q
l
d
u
m
p
−
u
{DATABASES};do /usr/local/mysql/bin/mysqldump -u
DATABASES;do/usr/local/mysql/bin/mysqldump−uUSER -p$PASSWORD --events -R --opt
D
A
T
A
B
A
S
E
∣
g
z
i
p
>
DATABASE |gzip >
DATABASE∣gzip>{BACKUP_DIR}/KaTeX parse error: Expected group after '_' at position 11: {DATABASE}_̲{DATE}.sql.gz
if [
?
=
=
0
]
;
t
h
e
n
e
c
h
o
"
? == 0 ];then echo "
?==0];thenecho"DATE–$DATABASE is backup succeed" >> $LOGFILE
else
echo “Database Backup Fail!” >> $LOGFILE
done
#判断数据库备份是否全部成功，全部成功就同步到异地备份f服务器
if [ $? == 0 ];then
/usr/bin/rsync -zrtopg --delete /data/backup/* root@192.168.10.10:/data/backup/ >/dev/null 2>&1
else
echo “Database Backup Fail!” >> $LOGFILE
#备份失败后向管理者发送邮件提醒
mail -s “database Daily Backup Fail!” $MAIL
fi
#删除30天以上的备份文件
find $BACKUP_DIR -type f -mtime +30 -name “*.gz” -exec rm -f {} ;
## 2、Nginx负载均衡服务器上监控Nginx进程的脚本
企业负载均衡层如果用到Nginx+Keepalived架构，而Keepalived无法进行Nginx服务的实时切换，所以这里用了一个监控脚本check\_nginx\_pid.sh，每隔5秒就监控一次Nginx的运行状态，如果发现有问题就关闭本机的Keepalived程序，让VIP切换到从Nginx负载均衡器上。
shell> vim check_nginx_pid.sh
#!/bin/bash
while :
do
nginxpid=‘ps -C nginx --no-header | wc -l’
if ［
n
g
i
n
x
p
i
d
−
e
q
0
］
;
t
h
e
n
u
l
i
m
i
t
−
S
H
n
65535
/
u
s
r
/
l
o
c
a
l
/
n
g
i
n
x
/
s
b
i
n
/
n
g
i
n
x
s
l
e
e
p
5
n
g
i
n
x
p
i
d
=
′
p
s
−
C
n
g
i
n
x
−
−
n
o
−
h
e
a
d
e
r
∣
w
c
−
l
′
i
f
［
nginxpid -eq 0 ］;then ulimit -SHn 65535 /usr/local/nginx/sbin/nginx sleep 5 nginxpid='ps -C nginx --no-header | wc -l' if ［
nginxpid−eq0］;then ulimit−SHn65535 /usr/local/nginx/sbin/nginxsleep5 nginxpid=′ps−Cnginx−−no−header∣wc−l′ if［nginxpid -eq 0 ］;then
/etc/init.d/keepalived stop
fi
fi
sleep 5
done
## MySQL主从监控邮件报警脚本
此脚本应该能适应各种各样不同的内外网环境。
让脚本也顺便监控下MySQL是否正常运行。
Slave机器的IO和SQL状态都必须为YES，缺一不可，这里用到了多重条件判断-a。
shell> check_mysql_slave.sh
#!/bin/bash
#check MySQL_Slave Status
MYSQLPORT=‘netstat -na|grep “LISTEN”|grep “3306”|awk -F［:" "］+ ‘{print $4}’’
MYSQLIP='ifconfig eth0|grep “inet addr” | awk -F［:" "］+ ‘{print KaTeX parse error: Expected 'EOF', got '}' at position 2: 4}̲'' STATUS=(/usr/local/mysql/bin/mysql -u dbuser -dbpwd123 -S /tmp/mysql.sock -e “show slave status＼G” | grep -i “running”)
IO_env=‘echo $STATUS | grep IO | awk ’ {print $2}’’
SQL_env=‘echo $STATUS | grep SQL | awk ‘{print $2}’’
if ［ “$MYSQLPORT” == “3306” ］
then
echo “mysql is running”
else
mail -s “warn!server: $MYSQLIP mysql is down” magedu@gmail.com
fi
if ［ “
I
O
_
e
n
v
"
=
"
Y
e
s
"
−
a
"
IO\_env" = "Yes" -a "
IO_env"="Yes"−a"SQL_env” = “Yes” ］
then
echo “Slave is running!”
else
echo “####### $date #########”>> /data/log/check_mysql_slave.log
echo “Slave is not running!” >> /data/log/check_mysql_slave.log
mail -s “warn! $MySQLIP_replicate_error” magedu@gmail.com << /data/log/check_mysql_slave.log
fi
建议每10分钟运行一次：
shell> crontab -e
*/10 * * * * root /bin/sh /root/check_mysql_slave.sh
## 系统初始化脚本
此脚本用于新装Linux的相关配置工作，比如更换默认yum源，优化系统内核、停掉一些没必要启动的系统服务等。此脚本尤其适合大批新安装的CentOS系列的服务器。适用于Centos7。
shell>vim cenots_7_system_init.sh
#!/bin/bash
Filename: centos7-init.sh
Author: magedu@gmail.com
#判断是否为root用户
if [ whoami != “root” ];then
echo " only root can run it"
exit 1
fi
#执行前提示
echo -e “\033[31m 这是centos7系统初始化脚本，将更新系统内核至最新版本，请慎重运行！\033[0m”
read -s -n1 -p “Press any key to continue or ctrl+C to cancel”
echo “Your inputs: $REPLY”
#1.定义配置yum源的函数
yum_config(){
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
yum clean all && yum makecache
}
#2.定义配置NTP的函数
ntp_config(){
yum –y install chrony
systemctl start chronyd && systemctl enable chronyd
timedatectl set-timezone Asia/Shanghai && timedatectl set-ntp yes
}
#3.定义关闭防火墙的函数
close_firewalld(){
systemctl stop firewalld.service &> /dev/null
systemctl disable firewalld.service &> /dev/null
}
#4.定义关闭selinux的函数
close_selinux(){
setenforce 0
sed -i ‘s/enforcing/disabled/g’ /etc/selinux/config
}
#5.定义安装常用工具的函数
yum_tools(){
yum install –y vim wget curl curl-devel bash-completion lsof iotop iostat unzip bzip2 bzip2-devel
yum install –y gcc gcc-c++ make cmake autoconf openssl-devel openssl-perl net-tools
source /usr/share/bash-completion/bash_completion
}
#6.定义升级最新内核的函数
update_kernel (){
rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
rpm -Uvh http://www.elrepo.org/elrepo-release-7.0-3.el7.elrepo.noarch.rpm
yum --enablerepo=elrepo-kernel install -y kernel-ml
grub2-set-default 0
grub2-mkconfig -o /boot/grub2/grub.cfg
}
#执行脚本
main(){
yum_config;
ntp_config;
close_firewalld;
close_selinux;
yum_tools;
update_kernel;
}
main
## mysql数据库定时备份
**操作步骤：**
>
> 1、将脚本放到任意位置下，不容易被误删即可
> 2、定时任务，一周执行一次脚本
>
>
>
**脚本如下：**
#!bin/bash
backuppath=/data/mysql/backup
date=$(date +%Y%m%d%H%M)
SQLuser=root
SQLpwd=password
mysqldump=/usr/local/mysql/bin/mysqldump
mysql=/usr/local/mysql/bin/mysql
HIS_Date=date -d $(date -d "-30 day" +%Y%m%d) +%s #取30天之前的时间戳
Sql_Date=date -d $(date -d "-7 day" +%Y%m%d) +%s #取7天之前的时间戳
#进入mysql数据库，清除zabbix历史数据
m y s q l − u mysql -u mysql−uSQLuser -p$SQLpwd -e"
use zabbix;
delete from history WHERE 'clock' < $Sql_Date;
delete from history_uint WHERE 'clock' < $Sql_Date;
delete from history_str WHERE 'clock' < $Sql_Date;
delete from history_text WHERE 'clock' < $Sql_Date;
delete from history_log WHERE 'clock' < $Sql_Date;
exit
"
#建立备份目录
if [ ! -e $backuppath ];then
mkdir -p $backuppath
fi
**#开始备份zabbix库**
m y s q l d u m p − u mysqldump -u mysqldump−uSQLuser -p S Q L p w d z a b b i x > SQLpwd zabbix > SQLpwdzabbix>backuppath/zabbix$date.sql
**#删除1个月前的备份数据**
find /data/mysql/backup -mtime +30 -type f -name \zabbix*.sql -exec rm -f {} ;
在数据库历史数据过大，可以考虑truncate掉历史数据。
m y s q l − u mysql -u mysql−uSQLuser -p$SQLpwd -e"
use zabbix;
truncate table history;
truncate table history_log;
truncate table history_uint;
truncate table history_str;
truncate table history_text;
exit
"
## mysql定时备份脚本
**1:备份脚本**
包含备份，删除原文件，删除20天以前的备份文件
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
