monitor-replication.txt<\/a>] ( ** Check Updated Monitoring Script. )<\/p>\n<?php<\/span><\/p>\n #Resets warning messages<\/span><\/p>\nerror_reporting(E_ALL ^ E_NOTICE);<\/span><\/p>\n <\/span><\/p>\n#Function to display slave status.<\/span><\/p>\nfunction slavestatus($host,$username,$password,$slaveport=3306)<\/span><\/p>\n{<\/span><\/p>\n$con=mysql_connect(“$host:$slaveport”,$username,$password)<\/span><\/p>\nor die(“can’t connect server”);<\/span><\/p>\n$result=mysql_query(“show slave status”);<\/span><\/p>\n$timeResult=mysql_query(“select now()”);<\/span><\/p>\n$time=mysql_result($timeResult,0,0);<\/span><\/p>\n <\/span><\/p>\nwhile($status = mysql_fetch_array($result))<\/span><\/p>\n{<\/span><\/p>\n$file=$status[5];<\/span><\/p>\n$position=$status[6];<\/span><\/p>\n$sql_run=$status[10];<\/span><\/p>\n$io_run=$status[11];<\/span><\/p>\n$errorNum=$status[18];<\/span><\/p>\n$errorMeg=$status[19];<\/span><\/p>\n}<\/span><\/p>\n <\/span><\/p>\nprint “<tr align=center><\/span><\/p>\n<td> $time <\/td><\/span><\/p>\n<td> $host : $slaveport <\/td><\/span><\/p>\n<td> $file <\/td><\/span><\/p>\n<td> $position <\/td><\/span><\/p>\n<td> $sql_run <\/td><\/span><\/p>\n<td> $io_run <\/td><\/span><\/p>\n<td> $errorNum <\/td><\/span><\/p>\n<td> $errorMeg <\/td><\/span><\/p>\n<td> <form name=’form’ action=’#’ method=’POST’><\/span><\/p>\n<input type=’submit’ name=’stop’\u00a0 id=’stop’\u00a0 value=\\”STOP $host:$slaveport\\”><\/span><\/p>\n<input type=’submit’ name=’start’\u00a0 id=’start’\u00a0 value=\\”START $host:$slaveport\\”><\/span><\/p>\n<\/form> <\/td><\/span><\/p>\n<td> <a href=’?detail=$host:$slaveport’> detailed <\/a><\/td><\/span><\/p>\n<\/tr>”;<\/span><\/p>\n}<\/span><\/p>\n <\/span><\/p>\n#Function for starting and stopping mysql server.<\/span><\/p>\nfunction start_stop($machine,$username,$password,$task=’no’)<\/span><\/p>\n{<\/span><\/p>\nif($task==’no’) exit;<\/span><\/p>\n$con=mysql_connect($machine,$username,$password) or die(“can’t connect server”);<\/span><\/p>\n$sql= $task . ” slave”;<\/span><\/p>\n$result=mysql_query($sql);<\/span><\/p>\n$_POST = array();<\/span><\/p>\n$task=”no”;<\/span><\/p>\n$VAR=$_SERVER[“REQUEST_URI”];<\/span><\/p>\n <\/span><\/p>\n#Refreshes page, updates server status in table.<\/span><\/p>\nheader(‘refresh: 1; url=’.$VAR);<\/span><\/p>\n}<\/span><\/p>\n <\/span><\/p>\n#Function for showing detailed status<\/span><\/p>\nfunction get_status($machine,$username,$password)<\/span><\/p>\n{<\/span><\/p>\n$hostname = $_SERVER[‘SCRIPT_NAME’];<\/span><\/p>\necho “<center><a href=\\”$hostname\\”>Reset<\/a><\/center>”;<\/span><\/p>\nif($task==’no’) exit;<\/span><\/p>\n$con=mysql_connect($machine,$username,$password) or die(“can’t connect server”);<\/span><\/p>\n$sql=”show global status”;<\/span><\/p>\necho “<table border=1 align=center><tr><th>Variable<\/th><th>Value<\/th><\/tr>”;<\/span><\/p>\n$res=mysql_query($sql);<\/span><\/p>\nwhile($row = mysql_fetch_assoc($res))<\/span><\/p>\n{<\/span><\/p>\necho ‘<tr align=center><td>’.$row[‘Variable_name’].<\/span><\/p>\n‘<\/td><td>’.$row[‘Value’].'<\/td><\/tr>’;<\/span><\/p>\n}<\/span><\/p>\necho “<\/table>”;<\/span><\/p>\n#$_POST = array();<\/span><\/p>\n$task=”no”;<\/span><\/p>\n}<\/span><\/p>\n <\/span><\/p>\necho ‘<html>’;<\/span><\/p>\nif(!isset($_GET[‘detail’]))<\/span><\/p>\n{<\/span><\/p>\n#Auto refreshing page for continuous status<\/span><\/p>\n#content=”3;” page refreshes after 3 seconds<\/span><\/p>\necho ‘<meta http-equiv=”refresh” content=”3;”>’;<\/span><\/p>\n}<\/span><\/p>\necho'<body><\/span><\/p>\n<h1><font face=”verdana” size=10><small><\/span><\/p>\nMySQL Replication Monitor<\/small><\/font><\/h1>’;<\/span><\/p>\n <\/span><\/p>\n#host-name & ports for replication servers<\/span><\/p>\n$slave = “localhost”;<\/span><\/p>\n$master = “localhost”;<\/span><\/p>\n$slaveport=3306;<\/span><\/p>\n$masterport=3307;<\/span><\/p>\n <\/span><\/p>\n#considered a common username password for accessing both servers<\/span><\/p>\n$username=”root”;<\/span><\/p>\n$password=”kedar”;<\/span><\/p>\n <\/span><\/p>\nprint “<table border=1><tr><\/span><\/p>\n<th> time <\/th><\/span><\/p>\n<th> host : port <\/th><\/span><\/p>\n<th> file <\/th><\/span><\/p>\n<th> position <\/th><\/span><\/p>\n<th> io run <\/th><\/span><\/p>\n<th> sql run <\/th><\/span><\/p>\n<th> errorNum <\/th><\/span><\/p>\n<th> errorMeg <\/th><\/span><\/p>\n<th> Stop \/ Start <\/th><\/span><\/p>\n<th> Extra <\/th><\/span><\/p>\n<\/tr>”;<\/span><\/p>\n <\/span><\/p>\nslavestatus($slave,$username,$password,$slaveport);<\/span><\/p>\nslavestatus($master,$username,$password,$masterport);<\/span><\/p>\nprint “<\/table>”;<\/span><\/p>\n <\/span><\/p>\nif (isset($_POST[‘start’])) {<\/span><\/p>\nlist($task,$machine)=split(” “,$_POST[‘start’]);<\/span><\/p>\nstart_stop($machine,$username,$password,$task);<\/span><\/p>\n}<\/span><\/p>\n <\/span><\/p>\nif (isset($_POST[‘stop’])) {<\/span><\/p>\nlist($task,$machine)=split(” “,$_POST[‘stop’]);<\/span><\/p>\nstart_stop($machine,$username,$password,$task);<\/span><\/p>\n}<\/span><\/p>\n