Shell script to restart MySQL server if it is killed or not working

Mon, 06 Apr 2009 19:26:22 -0700

From the page: "#!/bin/bash # Shell script to restart MySQL server if it is killed or not working # due to ANY causes. # When script detects mysql is not running (it basically sends ping request # to MySQL) it try to start using /etc/init.d/mysql script; and it sends an # email to user indicating the status. # This script must be run from Cron Job so that it can monitor mysql server. # For more info visit following url: # http://www.cyberciti.biz/nixcraft/vivek/blogger/2005/08/linux-mysql-server-monitoring.html # -------------------------------------------------------------------------- # Copyright (C) 2005 nixCraft project /cyberciti.biz/fb/> # This script is licensed under GNU GPL version 2.0 or above # ------------------------------------------------------------------------- # This script is part of nixCraft shell script collection (NSSC) # Visit http://bash.cyberciti.biz/ for more information. # ------------------------------------------------------------------------- # mysql root/admin username MUSER="root" # mysql admin/root password MPASS="SET-ROOT-PASSWORD" # mysql server hostname MHOST="localhost" #Shell script to start MySQL server i.e. path to MySQL daemon start/stop script. # Debain uses following script, need to setup this according to your UNIX/Linux/BSD OS. MSTART="/etc/init.d/mysql start" # Email ID to send notification EMAILID="notification@somewhere-corp.com" # path to mail program MAILCMD="$(which mail)" # path mysqladmin MADMIN="$(which mysqladmin)" #### DO NOT CHANGE anything BELOW #### MAILMESSAGE="/tmp/mysql.fail.$$" # see if MySQL server is alive or not # 2&1 could be better but i would like to keep it simple and easy to # understand stuff :) $MADMIN -h $MHOST -u $MUSER -p${MPASS} ping 2>/dev/null 1>/dev/null if [ $? -ne 0 ]; then echo "" >$MAILMESSAGE echo "Error: MySQL Server is not running/responding ping request">>$MAILMESSAGE echo "Hostname: $(hostname)" >>$MAILMESSAGE echo "Date & Time: $(date)" >>$MAILMESSAGE # try to start mysql $MSTART>/dev/null # see if it is started or not o=$(ps cax | grep -c ' mysqld$') if [ $o -eq 1 ]; then sMess="MySQL Server MySQL server successfully restarted" else sMess="MySQL server FAILED to restart" fi # Email status too echo "Current Status: $sMess" >>$MAILMESSAGE echo "" >>$MAILMESSAGE echo "*** This email generated by $(basename $0) shell script ***" >>$MAILMESSAGE echo "*** Please don't reply this email, this is just notification email ***" >>$MAILMESSAGE # send email $MAILCMD -s "MySQL server" $EMAILID < $MAILMESSAGE else # MySQL is running :) and do nothing : fi # remove file rm -f $MAILMESSAGE"

Flickr: Discussing Cheap Macro Alternatives in SONY ALPHA DSLR-A200/A230

Wed, 06 Aug 2008 23:06:45 -0700

Example is for Sony A200, but applicable to all DSLRs.

12 Tips To Save Fuel That You're Still Not Doing! - HTNet

Wed, 23 Jul 2008 21:01:27 -0700

Save fuel now.

SPEED TRAP Spot - Central Region (Selangor, Kuala Lumpur, Negeri Sembilan & Melaka) | Ezzy Get A Car

Tue, 22 Jul 2008 22:46:30 -0700

Police speed trap haunts on Malaysian highways.

Simple And Quick Ways To Create Web Pages - HTNet

Tue, 15 Jul 2008 02:18:28 -0700

Create simple web pages with software already installed on your PC!

Index of /mobil ting/java

Wed, 16 Apr 2008 02:26:19 -0700

List of somebody's collection of mobile phone (cell phone) java games.

Better Permalink URLs For Your WordPress Blog - HTNet

Sun, 06 Apr 2008 22:19:36 -0700

Use post permalinks that doesn't suck.

ICK. Good luck to those opening the other cans. - Lainie: artword addict

Fri, 28 Mar 2008 01:05:10 -0700

Careful when consuming Campbell's soups.

Upgrading Your WordPress Installation Via SSH - HTNet

Mon, 17 Mar 2008 01:18:50 -0700

Step by step guide on how to upgrade WordPress via SSH.

http://themaskedmillionaire.com/2008/03/01/i-won-the-lottery.aspx

Fri, 14 Mar 2008 02:32:10 -0700

What would you do if you won $350 million dollars from the lottery? Blog about it!

StumbleUpon | Azmeen's comments & reviews