Submitted by:Egor Puzanov

This ZenPack provides monitoring of MySQL databases.There is a community.sql.MySqlDatabaseMap zCollectorPlugin that the device will need to use.

• MySQL - Command Statistics
• MySQL - Select Statistics
• MySQL - Handler Statistics
• MySQL - Network Traffic
• Database
  • MySQL - Database Size

Screenshots:

REQUIREMENTS:

Zenoss Version: 2.5, 3.0

ZenPack Dependencies:

• RDBMS Monitoring
• SQL Data Source

External Dependencies:

• The following zProperties need configuration:
  • zMySqlConnectionString - Connection String
  • zMySqlPorts - TCP Ports (one TCP port number per line)
  • zMySqlUsername - username
  • zMySqlPassword - password

Installation: Install all dependencies in order.

Source: https://github.com/epuzanov/ZenPacks.community.MySQLMon

Tagged Releases:

• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mysql-odbc-1.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mysql-odbc-2.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mysql-odbc-2.1
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mysql-odbc-2.2
• http://github.com/epuzanov/ZenPacks.community.MySQLMon_ODBC/tree/mysql-odbc-3.1
• http://github.com/epuzanov/ZenPacks.community.MySQLMon/tree/mysqlmon-3.2
• http://github.com/epuzanov/ZenPacks.community.MySQLMon/tree/mysqlmon-3.3

Change History:

• 1.0 initial release
• 2.0 converted to Zenoss 2.5 and use of either ODBC driver or pyodbc
• 2.1 fixed typo in database name
• 2.2 Zenoss 3.0 support
• 3.0 support for multiple database server instances, removed ODBC dependencies.
• 3.1 fix modeler plugin
• 3.2 switch from ODBC data source to SQL data source
• 3.3 DB and FileMaker Events classes are removed
  

Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1

Known issues: