[Nagiosplug-devel] nagios external plugin for mysql

[william(at)elan.net]

On Mon, 14 May 2007, Md Hasnain wrote:

> Hi guyz,
>
> Do you know any plugin which will externally monitor mysql databases and
> send reports through email and smtpreceiver will receive it and purge it
> check if there is any problem in the database. Please let me know if you
> know any.

I'm unclear of what you're asking. Nagios already includes plugin
for mysql and you should try using that and configure email reports 
through nagios. Personally I've written my own plugin in perl
to check mysql which I use in part because it runs faster inside
(with embedded perl) and because it also provides all the data
from "SHOW STATUS" and allows to set warnings based on if something
is out of balance there. You're welcome to try it, see
http://william.leibzon.org/nagios/plugins/check_mysqld.pl
(and if you want you maybe able to use it as base for custom perl
daemon that checks mysql and emails). Also MySQL AB provides SQLNet
as commercial application for those who buy mysql support - this is 
nagios-like monitoring system but entirely for purposes of checking
on sql databases - its very comprehensive but if you have large 
install that maybe of interest to you, see http://www.mysql.com
for more info.

-- 
William Leibzon
Elan Networks
william at elan.net