Notes for MySQL monitoring by sitescope

Monitoring MySQL Databases
Monitoring a MySQL database requires the use of a JDBC driver. To enable sitescope to monitor a MySQL database:

 

Download the JDBC driver from http://www.mysql.com/downloads/api-jdbc.html
Uncompress the distribution file
Among all the other files, you should find a file with a. Jar extension.
Copy the. jar file into the <sitescope install path>/sitescope/Java/lib/EXT directory

Stop and restart sitescope
Now, use your browser to add a database query monitor within sitescope.
The database connection URL format for the MySQL JDBC driver is:

JDBC: mysql: // <database hostname> [: <TCP port>]/<database>

 

For example to connect to the MySQL database "abigdatabase" on a machine using the standard MySQL port number 3306 you wowould use:
JDBC: mysql: // 206.168.191.19/abigdatabase

 

If you are using a different port to connect to the database then you shoshould include that port number as part of the IP address.

The specification for the MySQL JDBC driver is: org. gjt. Mm. MySQL. Driver

Enter this string into the database driver text box under the advanced options section of the add database query monitor form.