mysqld异常重启后，自动启动应用srm进程

#!/usr/bin/python

#-*- coding: utf-8 -*-

import paramiko

import os

import commands

import time

os.environ['PATH'] = '$PATH:$HOME/bin:/veris/usr/bin:/veris/usr/sbin'

os.environ['LD_LIBRARY_PATH'] = '/veris/usr/lib64:$LD_LIBBRARY_PATH'

port=5320

veris_name="billing"

error_file="/veris/%s/mysql/%d/log/error/error_%d.log" % (veris_name,port,port)

if os.path.isfile(error_file):

if "mysqld restarted" in open(error_file).read():

check_mysql_cmd = "mysqladmin -h127.0.0.1 -P%d -uroot -pxxxxxx ping 2>/dev/null" % port

try:

is_up=commands.getoutput(check_mysql_cmd)

except Exception, err1:

print err1

if is_up == "mysqld is alive":

ssh = paramiko.SSHClient()

ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())

ssh.connect("10.1.196.90",22,"aibilling", "123456")

try:

stdin, stdout, stderr = ssh.exec_command("srm")

except Exception, err2:

print err2

print stdout.read()

ssh.close()

error_path=os.path.dirname(error_file)

error_name=os.path.basename(error_file)

os.rename(error_file,error_path + os.sep + "bak" + os.sep + time.strftime('%Y%m%d.%H%M.') + error_name)