1.3.1 Adding Targets Manually

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.

Note

When adding a MySQL target, the system automatically deploys the plugin to the Management Agent on the target host if the plugin is not already deployed.

1. From the Setup menu, select Add Target, and select Add Targets Manually.

2. In the Add Targets Manually page, select Add Targets Declaratively.

   The Add Target Declaratively dialog is displayed.

3. Click the search icon by the Host field to open the Search Host dialog. Search for and select the required host name. Click Select to return to the Add Target Declaratively dialog.

4. In the Target Type field, select MySQL Database, MySQL InnoDB Cluster, MySQL InnoDB ClusterSet.

5. Click Add.

6. Complete the following fields:

   • Target Name: A unique name for the target. This value is displayed in the All Targets page.

   • MySQL User: The user name 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 host name 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.

   • Kerberos Keytab Path: The path to the Kerberos keytab file. Only specify a value if the Kerberos connection method is used.

   • Kerberos Principal: The principal used to connect to the database. Only specify a value if the Kerberos connection method is used.

   • 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.

   • Use Secure? (yes/no/require): Use secure connection. Specify a value only if using TLS. Default is no.

7. Click OK to save the target.

8. Click Targets and select All Targetsto return to the All Targets page.

   The new target is displayed as MySQL Database, MySQL InnoDB Cluster, or MySQL InnoDB ClusterSet in the Databases Target Type.

Important

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 plugin 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.