自动打包mysql下binlog日志

231232133

一、需求

线上一台机器做了rsync,从5台mysql机器拉取binlog日志到本地，之前是手动打包，现在写了个脚本，放到crontab定期执行打包，并删除打包后的的文件。

二、脚本如下

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114

#!/bin/sh # usage: # nohup sh /tmp/backup_binlog_tar.sh > nohup.out  2>/dev/null  & dir_backup_tar="/data0/backup_log-bin_tar"_`date +%Y-%m-%d--%H-%M-%S` echo $dir_backup_tar mkdir -p $dir_backup_tar #!/bin/sh # usage: # nohup sh /tmp/backup_binlog_tar.sh > nohup.out  2>/dev/null  & dir_backup_tar="/data0/backup_log-bin_tar"_`date +%Y-%m-%d--%H-%M-%S` echo $dir_backup_tar mkdir -p $dir_backup_tar dir_binlog_140="/data0/backup_log-bin/140/log-bin" dir_binlog_141="/data0/backup_log-bin/141/log-bin" dir_binlog_145="/data0/backup_log-bin/145/log-bin" dir_binlog_146="/data0/backup_log-bin/146/log-bin" dir_binlog_182="/data0/backup_log-bin/182/log-bin" instance_seq=140 dir_binlog=$dir_binlog_140 if [ ! -d $dir_binlog ]; then         echo "$dir_binlog is not exit and skip!" fi for instance in `ls $dir_binlog` do         cd $dir_binlog         tar -zcf $dir_backup_tar/"$instance_seq""_""$instance"".tar.gz" $instance         if [ $? -eq 0 ];then                 echo "delete $dir_binlog/$instance/* ..."                 rm -rf $dir_binlog/$instance/*         else                 echo "tar $dir_binlog/$instance failed!!!"         fi done instance_seq=141 dir_binlog=$dir_binlog_141 if [ ! -d $dir_binlog ]; then         echo "$dir_binlog is not exit and skip!" fi for instance in `ls $dir_binlog` do         cd $dir_binlog         tar -zcf $dir_backup_tar/"$instance_seq""_""$instance"".tar.gz" $instance         if [ $? -eq 0 ];then                 echo "delete $dir_binlog/$instance/* ..."                 rm -rf $dir_binlog/$instance/*         else                 echo "tar $dir_binlog/$instance failed!!!"         fi done instance_seq=145 dir_binlog=$dir_binlog_145 if [ ! -d $dir_binlog ]; then         echo "$dir_binlog is not exit and skip!" fi for instance in `ls $dir_binlog` do         cd $dir_binlog         tar -zcf $dir_backup_tar/"$instance_seq""_""$instance"".tar.gz" $instance         if [ $? -eq 0 ];then                 echo "delete $dir_binlog/$instance/* ..."                 rm -rf $dir_binlog/$instance/*         else                 echo "tar $dir_binlog/$instance failed!!!"         fi done instance_seq=146 dir_binlog=$dir_binlog_146 if [ ! -d $dir_binlog ]; then         echo "$dir_binlog is not exit and skip!" fi for instance in `ls $dir_binlog` do         cd $dir_binlog         tar -zcf $dir_backup_tar/"$instance_seq""_""$instance"".tar.gz" $instance         if [ $? -eq 0 ];then                 echo "delete $dir_binlog/$instance/* ..."                 rm -rf $dir_binlog/$instance/*         else                 echo "tar $dir_binlog/$instance failed!!!"         fi done instance_seq=182 dir_binlog=$dir_binlog_182 if [ ! -d $dir_binlog ]; then         echo "$dir_binlog is not exit and skip!" fi for instance in `ls $dir_binlog` do         cd $dir_binlog         tar -zcf $dir_backup_tar/"$instance_seq""_""$instance"".tar.gz" $instance         if [ $? -eq 0 ];then                 echo "delete $dir_binlog/$instance/* ..."                 rm -rf $dir_binlog/$instance/*         else                 echo "tar $dir_binlog/$instance failed!!!"         fi done