check_mysql

#!/usr/bin/python
import sys, os, pwd
import getopt
import commands
import subprocess
import platform

STATE_OK=0
STATE_WARNING=1

dist = platform.dist()
if dist[0] == "debian":
    command = "/usr/sbin/service mysql status"
elif dist[0] == "centos":
    command = "/sbin/service mysqld status"
else:
    command = "service mysql status"

check_mysql=subprocess.Popen(command, shell=True, stdout=subprocess.PIPE)
mysql_status=check_mysql.communicate()[0]

if "run" in mysql_status:
   print "Mysql is Running"
   sys.exit(STATE_OK)
else:
   print "Mysql is NOT Running !!"   
   sys.exit(STATE_WARNING)

sys.exit(STATE_OK)