这篇文章上次修改于 2451 天前，可能其部分内容已经发生变化，如有疑问可询问作者。 #!/bin/sh unset LANG LC_ALL=C export LC_ALL PATH=$PATH:/usr/local/mysql/bin export PATH user=root password=xnjcwmysql master_host="192.168.0.250" port=3306 master_port=3306 backup_lv_name="/dev/vg/data" backup_path="/home/backup" backup_dir="mysql" backup_binlog_dir="binlog" backup_binlog_name="binlog_`date +%Y%m%d --date='1 days ago'`.tar.bz2" backup_binlog_expire="binlog_`date +%Y%m%d --date='8 days ago'`.tar.bz2" remote_backup_host="192.168.0.200" remote_backup_path="/data/databases" remote_backup_name="`date +%w --date='1 days ago'`.tar.bz2" remote_backup_binlog_name="binlog_`date +%w --date='1 days ago'`.tar.bz2" ## 刷新 master 的 binlog mysql -u$user -p$password -h$master_host -P$master_port -e 'flush logs' ## 停止 slave sleep 5 mysql -u$user -p$password -P$port -e 'slave stop' sleep 5 ## 创建 MySQL 数据 逻辑卷 的快照 modprobe dm-snapshot lvcreate -l 486 -s -n mysql_snap $backup_lv_name ## 启动 slave mysql -u$user -p$password -P$port -e 'slave start' ## 备份 binlog mkdir -p /mnt/mysql_snap mount /dev/vg/mysql_snap /mnt/mysql_snap cd /mnt/mysql_snap tar cjpf $backup_path/$backup_binlog_dir/$backup_binlog_name `ls | grep mysql-bin.[0-9]` ## 备份数据库文件 rsync -a --delete --exclude "mysql-bin.*" --exclude "*.MYI" --exclude "relay-log.info" /mnt/mysql_snap/ $backup_path/$backup_dir/ cp -af /mnt/mysql_snap/mysql/*.MYI $backup_path/$backup_dir/mysql/ #?把备的的 binlo压缩包包传送到远程备份主机scpcp $backup_path/$backup_binlog_d/r/$backup_binlog_name $remote_backup_ho:t:$remote_backup_path/$remote_backup_binlog_name ## 打包备份目录并传送到远程备份主机 cd $backup_path tar -cjpf - $backup_dir | ssh $remote_backup_host "cat > $remote_backup_path/$remote_backup_name" ## 删除快照 umount /mnt/mysql_snap lvremove -f /dev/vg/mysql_snap rm -rf /mnt/mysql_snap rmmod dm-snapshot ## 删除过期的 binlog rm -f $backup_path/$backup_binlog_dir/$backup_binlog_expire ## 清除已备份的 binlog curr_binlog=`mysql -u$user -p$password -P$port -e 'show slave status\G' | grep Master_Log_File | awk '{print $2}' | uniq` mysql -u$user -p$password -h$master_host -P$master_port -e 'purge master logs to "'$curr_binlog'"' mysql -u$user -p$password -P$port -e 'purge master logs to "'$curr_binlog'"'
没有评论