链接:https://pan.baidu.com/s/1HI8Tc8YnQn34lcuV3Tvtew 密码:45a1
链接:https://pan.baidu.com/s/1Lq4UHa7EbsBVlBAFbbMgpA 密码:b2zs
-----------------------------------------------------------------------------------------------------------
因为软件bug的原因:需要先安装
libev-4.04-2.el6.x86_64
rpm -ivh libev-4.04-2.el6.x86_64
安装XtraBackup-2.4.9
解压,然后安装
rpm -ivh p(tab)*
如之前有旧版本的xtrabackup,先卸载在安装
----------------------------------------------------------------------------------------------------------
MySQL全量备份脚本
#!/bin/bash
#-------------------------------------------------------------------------#
#每小时全备MySQL一次
#-------------------------------------------------------------------------#
IP=xxxx
#-------------------------------------------------------------------------#
#备份用的用户名
USER=xxxx
#-------------------------------------------------------------------------#
#备份用户的密码
PASSWORD=xxxx
#-------------------------------------------------------------------------#
#MySQL启动的文件
FILE=/var/lib/mysql/mysql.sock
#-------------------------------------------------------------------------#
#备份MySQL的放置位置
DIR=/MySQL_backup/
#-------------------------------------------------------------------------#
#MySQL的配置文件
file=/etc/my.cnf
#-------------------------------------------------------------------------#
#时间
TIME=`date +%F_%Hh_%Mm`
#MySQL端口
PORT=xxxx
#-------------------------------------------------------------------------#
innobackupex --defaults-file="$file" --host="localhost" --port="$PORT" --user="$USER" --password="$PASSWORD" --socket="$FILE" --stream=tar "$DIR" | gzip -> "/MySQL_backup/MySQL_backup_$TIME.tar.gz"
#-------------------------------------------------------------------------#
if [ $? -eq 0 ];then
rsync -av --delete /MySQL_backup/MySQL_backup_$TIME.tar.gz root@$IP:/MySQL_backup/
else
echo "${TIME}:MySQL备份失败" >> /root/MySQL_backup.log && echo 'Mysql_backup失败' | mail -s "MySQL_backup" [email protected]
fi
#-------------------------------------------------------------------------#
if [ $? -eq 0 ];then
find /MySQL_backup/* -mtime +6 -exec rm -rf {} \;
ssh root@$IP "find /MySQL_backup/* -mtime +6 -exec rm -rf {} \;"
fi
#-------------------------------------------------------------------------#