Regular cleanup of MySQL master-slave logs

MySQL master-slave binlog timed deletion is very important, generally through expire_logs_days = 10来 set binlog reserved Days (mysql5.0 version is not supported), but sometimes this is not enough, if a few days of log volume is very large, the hard disk may be full, so not only to set the number of days to keep, but also to monitor the space usage of the hard disk. Wrote a script, suitable for each version of MySQL, keep the 3-day log, when the log is stored in more than 80% of the hard disk, it is retained for 2 days, but at least one day of binlog log files are retained.

2. #!/bin/env python
4. #-*-Coding:utf-8-*-
6. ##############################################################
8. #查看存在binlog的目录位置并找出3天前的最后一个bin-log file name
10. #删除3天以前的binlog文件, after the data1 directory is removed, the drive usage over
12. #过的80%, continue to delete the log file 2 days ago, keeping at least one day's log.
14. ##############################################################
18. Import Os,sys,time,mysqldb
22. def log_w (text):
24. LogFile = "/usr/local/zabbix/bin/delet.log"
26. now = Time.strftime ("%y-%m-%d%h:%m:%s")
28. tt = now + "\ T" + str (text) + "\ n"
30. f = open (logfile,' A + ')
32. F.write (TT)
34. F.close ()
38. def mysql_conn (port,lastlog,days):
40. Try:
42. Center_ip = ' 127.0.0.1 '
44. Center_user = ' Repl_monitor '
46. center_passwd = ' Vqmqlgwtaw3k0uv8 '
48. sql = "PURGE MASTER LOGS to '%s ';"% Lastlog
50. conn = MySQLdb.connect (host = Center_ip,port = Int (port), user = CENTER_USER,PASSWD = center_passwd,connect_timeout=5 ) 
52. cursor = Conn.cursor ()
54. Cursor.execute (SQL)
56. AllData = Cursor.fetchall ()
58. Cursor.close ()
60. Conn.close ()
62. Text = "Deltet before%s days Binlog,deltet%s before!"% (Days,lastlog)
64. Log_w (text)
66. except Exception,e:
68. Log_w (e)
72. Def find_logdir ():
74. conn = "Find/-name binlog|grep-v usr"
76. Logdir_list = Os.popen (conn). ReadLines ()
78. If Len (logdir_list)! = 0:
80. For LogDir in logdir_list:
82. DataDir = Logdir.strip (). Split ("/") [1]
84. if "Mysql_log" in Logdir.strip ():
86. Port = 3306
88. Else:
90. Port = Logdir.strip (). Split ("/") [3].split ("-") [-1]
92. Days = 3
94. while 1:
96. conn = "Find%s-mtime%s|sort"% (Logdir.strip (), days)
98. Count = Os.popen (conn). ReadLines ()
100. If Len (count)! = 0:
102. Lastlog = count[-1].strip (). Split ("/") [-1]
104. Mysql_conn (Port,lastlog,days)
108. DF = "Df-h|grep-e '%s$ ' |awk ' {print $} ' |awk-f ' percent ' ' {print '} '"% DataDir
110. Disk = Os.popen (DF). Read (). Strip ()
112. if not disk:
114. Break
116. Else:
118. if int (disk) < :
120. Break
122. Else:
124. Days = days- 1
126. if days = = 1:
128. Break
130. Else:
132. Sys.exit ()
136. if __name__ = = "__main__":
138. Find_logdir ()

This article is from "Wang Wei" blog, please be sure to keep this source http://wangwei007.blog.51cto.com/68019/1123088

Regular cleanup of MySQL master-slave logs