Pada Tue, 10 Sep 2002 11:03:40 +0100
"Tom Freeman" <[EMAIL PROTECTED]> menulis :
> Hi,
> I hope this question hasn't been asked loads of times before but I can't see
> any reference to it in the documentation.
> Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
> are using MySQL as the backend of some important sites and need to ensure
> that if it does crash for whatever reason, an alert (email and SMS) is sent
> out to an engineer to resolve the problem.
>
> We are presently using a program known as NetSaint to monitor our services
> but it sometimes doesn't seem to be 100% reliable at detecting a MySQL
> error.
>
> Anyway, can anyone tell me a better way to monitor MySQL so that if it has
> any problems an oncall engineer can respond quickly. I'm sure this must be a
> common problem so there must be something out there already.
>
Hi,
I usually use bofhlog, you can find it in freshmeat.net ... the purpose is for
"tailing" the log file.
And we configured bofhlog to monitor the error messages from <hostname>.err ... with
keyword : shutdown or restart ... if bofhlog found a line with one of these keywords,
then it will alarm you via anything you want (using other tools).
It's real time monitoring ;-)
--
C is quirky, flawed, and an enormous success
-- Dennis M. Ritchie
MySQL 3.23.51 : up 0 days, Queries : 776.454 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
