python2怎么监控多源复制状态并发邮件
本篇内容主要讲解“python2怎么监控多源复制状态并发邮件”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“python2怎么监控多源复制状态并发邮件”吧!
创新互联公司是一家从事企业网站建设、网站设计制作、做网站、行业门户网站建设、网页设计制作的专业的建站公司,拥有经验丰富的网站建设工程师和网页设计人员,具备各种规模与类型网站建设的实力,在网站建设领域树立了自己独特的设计风格。自公司成立以来曾独立设计制作的站点超过千家。
我们环境中用到了多源复制,因此写个查看状态的Python脚本,python为系统中自带的2.6.6,邮件内容为html格式,隔行变色,脚本如下:
# -*- coding: UTF-8 -*-
import smtplib
from email.mime.text import MIMEText
from email.header import Header
import datetime
import MySQLdb
date_end = datetime.date.today()
html_part1 = """
Report of 10.10.100.10 multi source repl status {current_time}
Master_Host |
Slave_IO_Running |
Slave_SQL_Running |
Seconds_Behind_Master |
Channel_Name |
""".format(current_time=date_end)
html_part2 = """
"""
td_bgcolor_num = 1
db = MySQLdb.connect("10.10.100.10","mysqldba","mysql-dba-168" )
cursor = db.cursor()
cursor.execute("show slave status")
results = cursor.fetchall()
with open('/tmp/slavesof10010.html',mode='w') as f:
f.write(html_part1)
for row in results:
Master_Host = row[1]
Slave_IO_Running = row[10]
Slave_SQL_Running = row[11]
Seconds_Behind_Master = row[32]
Channel_Name = row[-2]
if td_bgcolor_num%2==0:
td_bgcolor='#F0F0F0'
else:
td_bgcolor='#FFFFCE'
td_bgcolor_num += 1
pro = '''
'''+ row[1].encode('utf-8','ignore') + " | " + '''
'''+ row[10].encode('utf-8','ignore') + " | " + '''
'''+ row[11].encode('utf-8','ignore') + " | " + '''
'''+ str(row[32]) + " | " + '''
'''+ Channel_Name + ''' |
'''
f.write(pro)
f.write(html_part2)
db.close()
mail_host="smtp.xxxx.com"
sender = 'devops@xxxx.com'
receivers = ['devops@xxxx.com','123456789@qq.com','126@126.com','163@163.com']
with open('/tmp/slavesof10010.html',mode='r') as f:
html=f.read()
message = MIMEText(html, 'html')
message['From'] = Header("devops@xxxx.com")
message['To'] = Header(";".join(v for v in receivers))
subject = 'multi-source-repl of 100.10汇总'
message['Subject'] = Header(subject, 'utf-8')
try:
smtpObj = smtplib.SMTP()
smtpObj.connect(mail_host, 25) # 25 为 SMTP 端口号
smtpObj.sendmail(sender, receivers, message.as_string())
print "邮件发送成功"
except smtplib.SMTPException as e:
print "Error: 无法发送邮件",
print e计划任务
00 09 * * * python /server/scripts/get_html_10010.py &> /dev/null
到此,相信大家对“python2怎么监控多源复制状态并发邮件”有了更深的了解,不妨来实际操作一番吧!这里是创新互联网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
新闻标题:python2怎么监控多源复制状态并发邮件
分享URL:http://scyanting.com/article/joiece.html