Monitor Multiple MySQL Servers using PHP
This is a quick 1 page application to monitor your replicated MySQL servers.
Use it as you will. Enjoy!
The Code
<?php
$level = (int)$_GET['level'];
$refresh = (int)$_GET['refresh'];
function printServer($host,$user,$pass,$level=0){
$db = mysql_connect($host,$user,$pass,true);
mysql_select_db('factory_cre',$db);
echo '<div class="server">';
echo '<h2>'.$ip.'</h2>';
// Slave Status
$stats = mysql_fetch_assoc(mysql_query('SHOW SLAVE STATUS',$db));
echo '<h3>Slave Status</h3>';
echo '<dl>';
foreach($stats as $label=>$field) {
$class = array();
switch($label) {
case 'Seconds_Behind_Master':
if ($field!=0)
$class[]="error";
break;
case 'Slave_IO_Running':
if ($field!='Yes')
$class[]="error";
break;
case 'Slave_SQL_Running':
if ($field!='Yes')
$class[]="error";
break;
case 'Last_Error':
if ($field)
$class[]="error";
break;
}
echo '<dt>'.$label.'</dt><dd class="'.implode(' ',$class).'">'.str_replace(',',', ',$field).'</dd>';
}
echo '</dl>';
// Master Status
$stats = mysql_fetch_assoc(mysql_query('SHOW MASTER STATUS',$db));
echo '<h3>Master Status</h3>';
echo '<dl>';
foreach($stats as $label=>$field) {
$class = array();
echo '<dt>'.$label.'</dt><dd class="'.implode(' ',$class).'">'.str_replace(',',', ',$field).'</dd>';
}
echo '</dl>';
// Server Status
if ($level>0){
$stats = mysql_query('show status',$db);
echo '<h3>Server Status</h3>';
echo '<dl>';
while($row = mysql_fetch_assoc($stats)) {
$class = array();
echo '<dt class="'.implode(' ',$class).'">'.$row['Variable_name'].'</dt><dd class="'.implode(' ',$class).'">'.$row['Value'].'</dd>';
}
echo '</dl>';
}
mysql_close($db);
echo '</div>';
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<?php if($refresh): ?>
<meta http-equiv="refresh" content="<?php echo $refresh; ?>">
<?php endif; ?>
<title>MySQL Server Replication Status 2</title>
<style>
body {
font-family: Arial;
font-size: 78%;
}
h2 { padding: 0; margin:1em 0 0 0; }
.server{float:left;width:50%;}
.clear {clear:both}
.error {background:red}
dl {
line-height:1em;
margin: 0;
background: #F5FAFA;
border-top: 1px solid #77BBBF;
width: 95%;
margin: 0 auto;
}
dl.altrow {
background: #EFFFFF;
}
dt {
clear: both;
float: left;
width: 200px;
text-align: right;
padding-right: 10px;
font-weight: bold;
background: #C9E7E9;
padding-left: 1em !important;
border-top: 1px solid #EFFFFF;
border-left: 1px solid #77BBBF;
border-right: 1px solid #77BBBF;
border-bottom: 1px solid #77BBBF;
font-size: 11px;
font-family: "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #4f6b72;
}
dd {
margin-left: 220px !important;
padding-left: 10px !important;
border-top: 1px solid #fff;
border-left: 0;
border-right: 1px solid #77BBBF;
border-bottom: 1px solid #77BBBF;
min-height: 1em;
}
</style>
</head>
<body>
<h1>MySQL Replication Status</h1>
<a href="?refresh=0">Refresh off</a>
| <a href="?refresh=5">Refresh 5</a>
| <a href="?refresh=30">Refresh 30</a>
| <a href="?level=1">Expert</a>
<?php printServer('123.123.123.1','enter-server-1-username','enter-server-1-password',$level); ?>
<?php printServer('123.123.123.2','enter-server-2-username','enter-server-2-password',$level); ?>
<div class="clear"></div>
</body>
</html>
How It Looks
Bookmark/Search this post with:
ShareThis
Comments
No bad post, write more
Thanks for sharing.
It would be great if it could send an email when an error occurs.
Post new comment