The MySQL agent uses a JDBC connection to remotely gather MySQL STATUS and VARIABLES from a MySQL server. TPTP does not distribute a MySQL JDBC driver and this is a prerequisite before attempting to launch the MySQL data collection agent. The JDBC driver is available for download from the MySQL website (http://www.mysql.com/). The MySQL JDBC driver must be located on the machine that the agent controller is running on.
In order to monitor a MySQL database, select MySQL Server from the list of agent in the Agents Tab. This will again populate the Settings tab with the agent specific variables.
· The MySQL Host variable is the hostname or IP address of the MySQL server to connect to.
· The Database Name is the name of the database to connect to and query data from.
· The Username and Password should provide sufficient credentials to access the MySQL Server.
· The Remote JDBC Driver Location is the remote path (on the host that the Agent Controller is running on, and that was specified in the Host tab) to the MySQL JDBC driver that the agent can use to connect to the server.
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.