Database Testing

[Christopher Ferry]

I've been using the following check successfully:

                Service DB Replication {
                        frequency:      30
                        timeout:        120
                        retries:        2
                        retrydelay:     120
                        title:          MySQL Replication Status
                        label:          MySQL Replication Status
                        graph:          yes
                        drawgrid:       yes
                        ylabel:         Status
                        dsn:   
DBI:mysql:database=;host=dbhostname;port=3307
                        user:   youruser
                        pass:   yourpass
                        sql:    SHOW SLAVE STATUS
                        expect:  Yes
                        messagedn:  MySQL Replication Stopped!
                        notify: mail:youremail at here.com
 }

Your db user should only have process privileges.

Thanks

Chris Ferry



On Wed, 2004-03-03 at 15:35, Jeremy Kister wrote:
> 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/
> 
> 
> _______________________________________________
> http://argus.tcp4me.com/
> Arguslist at tcp4me.com
> http://www.tcp4me.com/mailman/listinfo/arguslist
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.tcp4me.com/pipermail/arguslist/attachments/20040304/857dfadb/attachment.bin