Crontab

Crontab Example

For every 5 min

In $crontab -e
5 * * * * /var/www/mysql_start.pl

#!/usr/bin/perl -w

#----------------------------
# Description
# starts mysql incase it is stopped
#--------------------------------

# Use of functions
	use strict;

# Variables
	my $date		= `date`;
	chomp $date;
	my $status      = `service mysql status`;
	my $logfile     = "/var/log/mysql.restart.log";
	my $log_fail    = $date." -> Mysql restarted";
	my $log_pass	= "\tMysql works fine";

# Function
	if ($status =~ m/.+stop.+/g) 
		{ 	`service mysql start`;
			open (F, ">>".$logfile);
			print F "$log_fail\n";
			close F;
		}
	else {
		open (F, ">>".$logfile);
		print F "$log_pass\n";
		close F;	

		}

#END