Skip navigation
Currently Being Moderated

MySQL SSH Monitor

VERSION 4  Click to view document history
Created on: Jun 30, 2010 9:43 PM by Matt Ray - Last Modified:  Aug 13, 2010 6:25 PM by Matt Ray

Submitted by: Matt Ray


Description:

This Monitoring ZenPack provides SSH-based monitoring of MySQL databases.  It was based off of the Core MySql Monitor ZenPack which requires port 3306 to be remotely accessible.  Rather than use remote access, this ZenPack connects to the MySQL server and performs the same SQL queries locally.  All other features of the ZenPack are identical to the original.  Please refer to the Zenoss Extended Monitoring Guide for configuration requirements.

 

Out of the box, the MySQL SSH ZenPack doesn't do much.  You will need to copy the check_mysql.sh script to the machines you wish to monitor and make sure the permissions are correct for the SSH user on the remote machine to access the script.  At the Device Class or individual device, you my "Override Template Here" and set the path to your check_mysql.sh script.

 

The following metrics are collected and graphed for MySQL servers that bind the MySQLSSH performance Template:

  • Command Statistics (SELECT, INSERT, UPDATE, DELETE)

  • Select Statistics (Scan, Range Check, Range Join,  Full Join)

  • Handler Statistics (Keyed and  Unkeyed Reads, Writes, Updates, Deletes)

  • Network  Traffic (Received and Sent)

 

The ZenPack also provides App/MySQL and Perf/DB events and MySQL software listings redundant with the original MySQL Monitor ZenPack.


Screenshots:

Screen shot 2010-06-30 at 9.05.33 PM.png

Screen shot 2010-06-30 at 9.05.49 PM.png

 


Installation Requirements:

  • Zenoss Versions Supported: 2.5 (py2.4), 3.0 (py2.6)
  • External Dependencies: mysql-client and check_mysql.sh need to be installed on the remote machine
  • ZenPack Dependencies: none
  • Installation Notes: zopectl restart after installing this ZenPack.  Please refer to the Zenoss  Extended Monitoring Guide for server configuration requirements.
  • Configuration: zCommandPassword or zKeyPath, zCommandUsername, zMySqlPassword and zMySqlUsername properties must be set.  You will need to adjust the path to check_mysql.sh within the datasource and bind the template, for example:
    /home/${here/zCommandUsername}/check_mysql.sh ${here/zMySqlUsername}  ${here/zMySqlPassword}

History:

Change History:

  • 0.4 initial release

Tested: This ZenPack was tested with versions 2.5.2 and 3.0.

Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.community.MySQLSSH

Tagged Releases:


Known issues:

Attachments:
Note: binary attachments ending in .zip will need to be unzipped before use.
Comments (10)