Cron script to check for MySQL replication problems

mysql-repl-check.py

#!/usr/bin/python -Wignore::DeprecationWarning
"""
Call this as a cron script to check for replication problems
"""
import MySQLdb

DB_HOST = '127.0.0.1'
DB_USER = 'USERNAME'
DB_PASSWD = 'PASSWORD'

conn = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASSWD)
cursor = MySQLdb.cursors.DictCursor(conn)
cursor.execute("show slave status");
row = cursor.fetchone()

if not (row["Slave_IO_Running"] == "Yes" and row["Slave_SQL_Running"] == "Yes" and
      row["Last_Errno"] == 0 and row["Seconds_Behind_Master"] < 120):
    print "MySQL replication error:"
    for k, v in row.iteritems():
        print "%s:\t%r" % (k, v)