MySQL

MySQL Plugin

The MySQL plugin discovers MySQL resources slightly different that other plugins. The plugin searches for the MySQL daemon using the PTQL functionality provided within SIGAR. From this top level process server you configure the JDBC connection parameters. The plugin then discovers each of your MySQL databases running on the MySQL instance and their associated tables.

Note that the plugin only discovers the first instance of MySQL running on a platform. If you have additional MySQL instances, you must add them to inventory explicitly. To do so, navigate to the platform that hosts the additional MySQL instance, and use the New Server command on the Tools menu to define a server for the instance.

MySQL Discovery on FreeBSD Since MySQL runs in multi-process mode on FreeBSD, the default SIGAR PTQL query of State.Name.eq=mysql will not work since it will return multiple processes. To work around this you can use the pid file to find the process by setting the PTQL query to Pid.PidFile.eq=/path/to/pidfile.

Download

• Included in the HQ distribution
• Grab the latest source code:

  svn co http://svn.hyperic.org/projects/hq/trunk hyperic-hq
  

Documentation

• MySQL Process 5.x server
• MySQL 5.x server
• MySQL 5.x Table service
• MySQL Process 4.x server
• MySQL 4.x server
• MySQL 4.x Table service
• MySQL Process 3.x server
• MySQL 3.x server
• MySQL 3.x Table service