Database Testing

[Jeremy Kister]

I am currently monitoring the health of my two slave MySQL servers via some
perl:
my $sql = 'show slave status';
my $sth = $dbh->prepare($sql);
$sth->execute;
my $row=$sth->fetchrow_hashref;
my $slave_io = $row->{Slave_IO_Running};
my $slave_sql = $row->{Slave_SQL_Running};

print "OK" if(($slave_io eq 'Yes') && ($slave_sql eq 'Yes'));

how can this be monitored from Argus's internal Database Testing Technique ?


Jeremy Kister
www.jeremykister.com/jeremy/