HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide

183
MySQL
MySQL is an open source database management system. As one of the important part, the
performance can impact the service directly; APM supports the monitor to MySQL.
APM can monitor MySQL 5.x.This chapter specify on how to add/modify the MySQL application
monitor and MySQL application monitor report.
Adding a MySQL application monitor
APM monitors the MySQL by server port (default value is 3306). You should be aware of the following
points when you add the application monitors:
• The host which has installed the MySQL should be joined the IMC platform. For more information,
see IMC Base Platform Administrator Guide.
• The users who logins in the MySQL need to have the administrator’s permission, the username and
the password.
To add My SQL application monitor:
1. Select Resource tab.
2. The operator can inter the Add Application page from the two ways:
 Select Application Management > Add Application in the menu. The page displays all of the
application types which can be monitored by APM.
 Select Application Management > Application Monitor in the menu. The page displays the
Application Monitor list. Click Add button.
3. Click MySQL of the Database Server monitor class, enter to the “Add-SQL Server” page.
4. In the Name textbox, input the application monitor name. The application monitor name should
be unique, you are better to use the format “application name_host IP address” as the application
monitor name.
5. In the Port textbox, input the MySQL service port, the default value is 3306.
6. In the Description textbox, input the details of the application monitor. The specific details are
helpful for the operator to manage it.
7. Click Select button, the Select Devices dialogue box pops up. Select the host which has installed
MySQL.
8. In the Polling Interval (min) drop list, select the polling query time interval, the unit is min. The
selected time interval includes: 1, 2,3,4,5,10,20,30. The shorter polling interval is, more
accurate the application running status will reflect. But this brings more workload for the APM
server.
9. If you want to modify the administrator’ username and password, type in new username and
password in the text box.
10. Modify the Contact information in the textbox. The contents include: name, e-mail, phone number
and so on.
11. Click Add to open the Select Application page, and select a related application, and then click
OK. Click Delete to delete the related application of the MySQL Server. The operators can view
the applications related to the MySQL Server in the application topology.