Hello, Do you want to perform �transaction monitoring� of MySQL? Basically, have WhatsUp Gold login to MySQL, search a table for the last name of �Smilgzdruvs� and notify if no response on a poll? We find that this is one of the best ways to confirm that the database is operational. You can do it with Denika for WhatsUp Gold for free:
Screen Capture: http://www.somix.com/img/screenshots/denika-trans-mon.gif Live Demonstration: Go to: http://denika:[EMAIL PROTECTED] Click on -> click on �Group� in the upper left hand corner -> click on �Report Groups 21� -> click on "DB Transaction Tests (2)" Free version: http://www.somix.com/products/denika_whats_up_gold_integration.php Have fun, Michael Patterson (207)324-8805 x222 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edgars Smilgzdruvs Sent: Wednesday, January 21, 2004 9:49 AM To: [EMAIL PROTECTED] Subject: RE: [WhatsUp Forum] how to monitor mysql Thanks Paul, but in this case you do monitor only TCP port (is it opened or not) , not MySQL daemon/DB work. Mostly, if mysql daemon goes down also goes down the TCP port too, but not in all cases (daemon config problems, sql user problems, DB problems etc..). ------------------------------- Edgars Smilgzdruvs IT division, LMT PH: +371-9248674 "Paul Jasa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 21.01.2004 14:56 Please respond to [EMAIL PROTECTED] To <[EMAIL PROTECTED]> cc Subject RE: [WhatsUp Forum] how to monitor mysql Someone on this group showed me how to do this last year (thanks, btw! �Love this group!!). �On the console (not web gui) �Go to: � Configure > Monitors and Services > �click "New" > name service MySQL and select Service Type "TCP/IP Service", click OK > �insert TCP port 3306, click OK � �now you have a new service called MySQL that checks port 3306 (btw, if you have your mysql running on a different non-standard port, then be sure to create the service for that port, and not 3306). �Create a new object with the IP �of the Mysql server and have it monitor JUST services, and insert the service to be MySQL which you created above. � Two things to keep in mind with this solution: 1) �you must set up your mysql server to accept connections from the outside (preferably ONLY your WUG server for security) 2) �if you're running iptables or other Linux firewall, be sure to allow port 3306 inbound from the outside (again, preferably ONLY from your WUG server for security) � Hope this helps!!~ pj ====================================== Paul Jasa Network Engineer ====================================== -----Original Message----- From: Edgars Smilgzdruvs [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 04:31 AM To: [EMAIL PROTECTED] Subject: [WhatsUp Forum] how to monitor mysql Hi all! Does anyone has any ideas how to monitor mysql server/daemon on linux? Thanks, ------------------------------- Edgars Smilgzdruvs IT division, LMT PH: +371-9248674 The information contained in this e-mail and any attached documents may be privileged, confidential and protected from disclosure. If you are not the intended recipient you may not read, copy, distribute or use this information. If you have received this communication in error, please notify the sender immediately by replying to this message and then delete it from your system. Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
