Database Testing

Jeremy Kister argus-01 at
Wed Mar 3 15:35:30 EST 2004

I am currently monitoring the health of my two slave MySQL servers via some
my $sql = 'show slave status';
my $sth = $dbh->prepare($sql);
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

More information about the Arguslist mailing list