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:
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:
