$time $host : $slaveport $file $position $sql_run $io_run $errorNum $errorMeg
detailed "; } #Function for starting and stopping mysql server. function start_stop($machine,$username,$password,$task='no') { if($task=='no') exit; $con=mysql_connect($machine,$username,$password) or die("can't connect server"); $sql= $task . " slave"; $result=mysql_query($sql); $_POST = array(); $task="no"; $VAR=$_SERVER["REQUEST_URI"]; #Refreshes page, updates server status in table. header('refresh: 1; url='.$VAR); } #Function for showing detailed status function get_status($machine,$username,$password) { $hostname = $_SERVER['SCRIPT_NAME']; echo "
Reset
"; if($task=='no') exit; $con=mysql_connect($machine,$username,$password) or die("can't connect server"); $sql="show global status"; echo ""; $res=mysql_query($sql); while($row = mysql_fetch_assoc($res)) { echo ''; } echo "
VariableValue
'.$row['Variable_name']. ''.$row['Value'].'
"; #$_POST = array(); $task="no"; } echo ''; if(!isset($_GET['detail'])) { #Auto refreshing page for continuous status #content="3;" page refreshes after 3 seconds echo ''; } echo'

MySQL Replication Monitor

'; print ""; slavestatus($slave,$username,$password,$slaveport); slavestatus($master,$username,$password,$masterport); print "
time host : port file position io run sql run errorNum errorMeg Stop / Start Extra
"; if (isset($_POST['start'])) { list($task,$machine)=split(" ",$_POST['start']); start_stop($machine,$username,$password,$task); } if (isset($_POST['stop'])) { list($task,$machine)=split(" ",$_POST['stop']); start_stop($machine,$username,$password,$task); } if (isset($_GET['detail'])) { echo "
Showing global status for: ". $_GET['detail'] . "

"; get_status($_GET['detail'],$username,$password); } echo '
Kedar.
'; ?>