Documentation Home
MySQL Enterprise Monitor 8.0 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 6.0Mb
PDF (A4) - 6.0Mb


16.3.1 Adding a MySQL Instance

This section describes how to monitor a MySQL instance.

Connection Settings

The Connection Settings tab

Figure 16.1 Add Instance Connection Settings

Content is described in the surrounding text.

Table 16.5 Connection Settings Tab

Name Description

Monitor From

Select an Agent from the list of Agents to monitor this MySQL database Instance.

It is recommend installing one Agent per Host and using that Agent to monitor all its MySQL Instances.

Set up the Agent as a local connection by specifying TCP/IP and an Instance Address of 127.0.0.1, or use a socket file. If there is no local Agent on the Host and you are unable to install one, use the built-in or another Agent to monitor remotely.

Note

If the instance is monitored remotely, it is not possible to retrieve any information on the host. To monitor a host, an agent must be installed on that host.

Connect Using

Select TCP/IP or a socket to connect to the instance. Socket connections can only be used for an Agent that is installed on the same machine as the target instance, and do not work with instances running on Windows.

Instance Address and Port

The IP address, or valid hostname, and port number the instance is listening on. If the host/agent chosen is local to this instance, you should use 127.0.0.1 here.

Admin User and Password

The root user, or user with the privileges defined in Creating the Admin User and the password.

Auto-Create Less Privileged Users

Choose Yes to create the General and Limited users on the MySQL instance. You must add a user name and password for both. For more information on these users, see Section 6.2, “Creating MySQL User Accounts for the Monitor Agent”.

Choose No if you intend to use the Admin user for all data collection.

Note

It is strongly recommend to use the General and Limited user.

General User and Password

Add a user name and password for the General User.

Limited User and Password

Add a user name and password for the Limited User.


Encryption Settings

Figure 16.2 Add Instance Encryption Settings

Content is described in the surrounding text.

Table 16.6 Encryption Settings Tab

Name Description

Require Encryption

Defines whether the connection uses TLS for security.

Allow Self-Signed Certificates

Specifies whether the connection permits self-signed certificates.

CA Certificate

Paste the CA certificate's contents here.

Note

This is not required if you are using a self-signed certificate.


Advanced Settings

Figure 16.3 Add Instance Advanced Settings

Content is described in the surrounding text.

Table 16.7 Advanced Settings

Name Description

Discover Replication Topologies

Specifies whether the agent attempts to discover if the instance is part of a replication group and discover the other members of that replication group.

When performing replication topology discovery, the agent attempts to read the slave's master.info, and use the stored credentials to log in to the master to read its inventory table and retrieve the master's UUID.

If set to No, no replication discovery is attempted.

MySQL Identity Source

Choose the mechanism used to generate a unique identity for the MySQL instance if one does not already exist.

  • Default: uses either the server_uuid variable if present, or generates a random new UUID

  • Host Plus Datadir generates a hash of the host identity and the path to the MySQL instances data directory to create a unique identity.

    Note

    Host Plus Datadir can be used only if the agent is running on the same host as the MySQL instance for this connection.

Inventory Table Schema

When the Agent connects to the MySQL Instance, it creates an inventory table, if one does not already exist, and stores two rows within it: a generated Instance UUID, and the host ID.

By default this is created within the mysql database. On shared hosts or cloud environments this may not be accessible to the Agent user; provide a database name to override where the inventory table is created.

Connection Timeout

Connection timeout, in milliseconds, used by the JDBC driver.

Socket Timeout

Socket timeout, in milliseconds, used by the JDBC driver.


Group Settings

Enter the groups to which you want to add the instance. It is also possible to define new groups in this field.

Note

To add groups, you must have the Server Group permission set to Read-Only, at least.

To create new groups, you must have the New Group Creation permission set to Administer.