批量清除过期的binlog日志释放磁盘空间的shell脚本

#!/bin/bash
#
#site:www.jiaochengji.com
for masterdb in `cat master.db.full`;do 
    #1 echo get the binlog position infomation 
    str_log_files=`ssh $masterdb "/opt/mysql/product/5.5.25a/bin/mysql -uroot --password="" -e \"show slave status\G;\" |grep -i master_Log_File "` 
    echo $str_log_files; 
    log_file=`echo $str_log_files | awk '{print $2}'`;  
    echo $log_file; 
 
    #2 echo get the master ip address or master hostname 
    db01tmp=`ssh $masterdb "  /opt/mysql/product/5.5.25a/bin/mysql  -uroot  --password=""  -e \"show slave status\G;\" |grep -i Master_Host  "`;   
    db01=`echo $db01tmp | awk '{print $2}'` 
 
    #3 begin to clear the old binlog  
    ssh $db01 "/opt/mysql/product/5.5.25a/bin/mysql  -uroot  --password="" -e \"purge master logs to '$log_file';\"" 
 
    #4 check the disk space for master 
    ssh $db01 "df -h" 
    echo " " 
    echo " -- -- -- "; 
done; 

for masterdb in `master.db.full`;do 
  ssh  $masterdb "df -h" |grep -i mysqldatadir; 
done;