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 MySQL database target, if the plug-in is not deployed on the host selected, 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.
The Add Target Declaratively dialog is displayed.
Click the search icon by the Host field to open the Search Host dialog. Search for and select the required hostname. Click Select to return to the Add Target Declaratively dialog.
In the Target Type field, select MySQL Database.
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.Note
If the MySQL server is configured with a bind address, you must use the configured bind address in this field.
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.