Mysql replication monitor and recovery. Set up the cronjob on mysql server (slave side) to run this script daily or weekly to monitor and recover from mysql replication failure. If there is any error an notification email will be sent to the email of your choice.

replication_monitor.sql

#!/bin/bash

USER=<your mysql username>
PASSWORD=<your mysql password>
SUBJECT="Mysql Replication Problem"
EMAIL=<your monitor email>

RESULT=`mysql -u$USER -p$PASSWORD -e 'show slave status\G' | grep Last_SQL_Error | sed -e 's/ *Last_SQL_Error: //'`
if [ -n "$RESULT" ]; then
   echo "$RESULT" | mail -s "$SUBJECT" $EMAIL
   mysql -u$USER -p$PASSWORD -e "STOP SLAVE;"
   mysql -u$USER -p$PASSWORD -e "SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;"
   mysql -u$USER -p$PASSWORD -e "START SLAVE;"
fi