You must configure a MySQL target that is monitored by Enterprise Manager Cloud Control. Metrics are not collected until the MySQL database is added as a target.
When adding a target, if the plug-in is not deployed on that target, the system automatically deploys the plug-in to the Management Agent on the target host.
From the Setup menu, select Add Target, and select Add Targets Manually.
In the Add Targets Manually page, select Add Targets Declaratively by Specifying Target Monitoring Properties .
In the Target Type field, select MySQL Database.
The Monitoring Agent field is displayed enabling you to search for a monitoring agent.
Click the search icon next to the Monitoring Agent field.
The Search and Select Targets page is displayed.
In the Target Type field, select Agent and click Search.
A list of available agents is returned.
Select the agent and click Select.
The Search and Select Targets page closes and Monitoring Agent field on the Add Targets Manually page is populated with the name of the selected Monitoring Agent.
On the Add Targets Manually page, click Add Manually.
The Add MySQL Database page is displayed.
Complete the following fields:
Target Name: A unique name for the target. This value is displayed in the All Targets page.
MySQL User: The username used to connect to the database. See Section 1.1, “Prerequisites” for more information on configuring this user.
MySQL Password: The password of the MySQL user.
Confirm MySQL Password: Re-enter the MySQL user password.
Host: The hostname of the MySQL
database. This can be an IP address or fully-qualified
name. If the database is local, you can specify
localhost. Specify a value only if
TCP/IP is the connection method used. Default host is
localhost.
Port: The port used to connect to the database. Specify a value only if TCP/IP is the connection method used. Default port is 3306.
Socket: The socket used to connect to the database. Specify a value only if socket is the connection method used.
Click OK to save the target.
Click Targets and select All Targetsto return to the All Targets page.
The new target is displayed as MySQL Database in the Databases Target Type.
Do not attempt to access the new target until a green arrow is displayed for the new target in the Target Status column.
It is also possible to monitor a remote MySQL database without deploying an agent or plug-in to that host. To remotely monitor a MySQL database, repeat these steps with an existing agent and, on the Add MySQL Database page, add the details for the remote database.
Remote monitoring does not allow monitoring of the host machine, only of the MySQL database running on that host.