Bulk purge of expired Binlog free disk space

program, a total of 24 db, a set to go in clean-up certainly not, you need to write a script, to do batch operations, the scenario is probably the following ideas

1, set up double master list masterlist; a master row.

2, remotely obtain the Binlog location above the master DB and the master hostname (perhaps IP address) corresponding to master

3, get the Binlog location and master hostname, then ssh remotely clean off the remote master above the Binlog

4, use shell for loop operation Step 2 and step 3.

The clearbinlog.sh script is as follows

[Python]View Plaincopy print?

2. For Masterdb in ' cat master.db.full ';d o
4. #1 Echo Get the binlog position infomation
6. 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 "'
8. echo $str _log_files;
10. Log_file= ' echo $str _log_files |   awk ' {print $} ';
12. echo $log _file;
16. #2 Echo Get the master IP address or master hostname
18. db01tmp= ' ssh $masterdb "/opt/mysql/product/5.5.25a/bin/mysql-uroot--password=""-e \" show Slave status\g;\ "    |grep-i master_host "';
20. Db01= ' echo $db 01tmp | awk ' {print $} '
24. #3 begin to clear the old Binlog
26. SSH $db "/opt/mysql/product/5.5.25a/bin/mysql-uroot--password=""-e \" Purge master logs to ' $log _file '; \ ""
30. #4 Check the disk space for master
32. SSH $db "Df-h"
34. echo ""
36. echo "------";
38. Done

Ok,run SH Script

SH clearbinlog.sh can start cleaning up all db binlog.

Finally, check disk space again and execute the check_disk.sh script with the following script:

[HTML]View Plaincopy print?

1. For Masterdb in ' Master.db.full ';d o
2. SSH $masterdb "df-h" |grep-i mysqldatadir;
3. Done

Execute SH check_disk.sh start check

Bulk purge of expired Binlog free disk space