Extended Monitoring Guide

Connect to the MySQL database by using the MySQL client:

mysql -u root

Alternatively, if there is a MySQL root password:

mysql -u root -p

Create a user for Zenoss to use. The username "zenoss" is recommended.

mysql> CREATE USER zenoss IDENTIFIED BY 'zenossPassword';

Query OK, 0 rows affected (0.00 sec)

Navigate to the device in the Zenoss interface.

From the page menu, select More → zProperties.

Edit the zMySqlRootPassword zProperty for the device or devices in Zenoss on which you want to monitor MySQL.

Click Save to save your changes.

From the page menu, select More → Templates.

From the table menu, select Bind Templates to display the Bind Performance Templates dialog.

To add the MySQL template and retain other performance templates, hold down the control key while clicking on the MySQL entry.

Click OK.

The MySQL template should now be displayed under the Performance Templates for Device. You will now be able to start collecting the MySQL server metrics from this device.

Navigate to the Perf tab and you should see some placeholders for graphs. After approximately fifteen minutes you should see the graphs start to become populated with information.