next »

[nutballs]

Anyone have any hint/idea of how to get notification that a mysql replication slave server is no longer updating?

Of course as I typed this, i just realized i could probably do it from php by just running the "show slave status" and looking for Slave_SQL_Running = Yes.

wonder if my base user has that priv...

[perkiset]

If you can replicate, you can see the status of it.

that's almost exactly what I did ... cron job checks it, emails me if it's not working. Kludgy but effective.

[nutballs]

Yep just got it working. Obviously you would trigger emails upon fail, instead of echoing, but thats semantic.

Quick and dirty:

on the slave in MYSQL:
GRANT REPLICATION CLIENT ON *.* TO 'slavemonitor'@'theremoteip' IDENTIFIED BY 'somepassword';

<?php
$dbhost = 'yourreplicationserver';
$dbuser = 'slavemonitor';
$dbpass = 'somepassword';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

$result = mysql_query("show slave status;") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo 'IO:'.$row['Slave_IO_Running'];
echo '<br />';
echo 'SQL:'.$row['Slave_SQL_Running'];
?>

[perkiset]

I have a really strong php email class, includes send, recv, imap ... the works. you need?

[nutballs]

nope im good.

this is actually exactly what I am doing. i realized i will just monitor this page with zenoss (which is what I use for my monitoring), and look for "SQL:Yes" and such.