Re: mysql heartbeat
Hi Pete, Zabbix looks pretty nice... does it allow you to get insight into currently running apps, such as checking on the health of individual tables within a db? ~mathew Pete Moran wrote: A monitoring solution which can monitor mysql as well as pretty much any service on nix and win platforms is zabbix (http://www.zabbix.com), its very easy to setup and personally I think its excellent. It may be overkill if you just want to check a db is up though -Original Message- From: Mathew Ray [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 February 2005 2:35 AM To: mysql@lists.mysql.com Subject: mysql heartbeat Has anyone used or built a db monitoring tool for MySQL? I have come across various system-level heartbeat tools, but I am specifically looking for a solution that will work on Win2K Server and RedHat boxes, as we have several servers that each run different instances of mysql. No replication or clustering here, just looking to get notification and execute some php if a specific db or table isn't accessible. I have a rough plan for making my own, but I thought I would check here to see if anyone had a suggestion... Thanks, ~mathew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql heartbeat
A monitoring solution which can monitor mysql as well as pretty much any service on nix and win platforms is zabbix (http://www.zabbix.com), its very easy to setup and personally I think its excellent. It may be overkill if you just want to check a db is up though -Original Message- From: Mathew Ray [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 February 2005 2:35 AM To: mysql@lists.mysql.com Subject: mysql heartbeat Has anyone used or built a db monitoring tool for MySQL? I have come across various system-level heartbeat tools, but I am specifically looking for a solution that will work on Win2K Server and RedHat boxes, as we have several servers that each run different instances of mysql. No replication or clustering here, just looking to get notification and execute some php if a specific db or table isn't accessible. I have a rough plan for making my own, but I thought I would check here to see if anyone had a suggestion... Thanks, ~mathew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql heartbeat
Hi Michael, thanks for the info. I guess I will go ahead with my plan to make something a little bit more robust that will check the avialability of every table of every db on a box and send out notifications on an interval until they are corrected. Seems like a nice little sourceforge project though... ~mathew Michael Dykman wrote: On Wed, 2005-02-16 at 10:35, Mathew Ray wrote: Has anyone used or built a db monitoring tool for MySQL? I have come across various system-level heartbeat tools, but I am specifically looking for a solution that will work on Win2K Server and RedHat boxes, as we have several servers that each run different instances of mysql. No replication or clustering here, just looking to get notification and execute some php if a specific db or table isn't accessible. I have a rough plan for making my own, but I thought I would check here to see if anyone had a suggestion... Thanks, ~mathew I don't know of anything in open source or shrink wrapped that does it, least of all cross-platform but perl and Java each run with good transparency on both *nix and Win32.. a script/program to perform basic heartbeat check would take less than an hour and be completely portable. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql heartbeat
On Wed, 2005-02-16 at 10:35, Mathew Ray wrote: > Has anyone used or built a db monitoring tool for MySQL? > > I have come across various system-level heartbeat tools, but I am > specifically looking for a solution that will work on Win2K Server and > RedHat boxes, as we have several servers that each run different > instances of mysql. > > No replication or clustering here, just looking to get notification and > execute some php if a specific db or table isn't accessible. I have a > rough plan for making my own, but I thought I would check here to see if > anyone had a suggestion... > > Thanks, > ~mathew I don't know of anything in open source or shrink wrapped that does it, least of all cross-platform but perl and Java each run with good transparency on both *nix and Win32.. a script/program to perform basic heartbeat check would take less than an hour and be completely portable. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]