10bet网址
MySQL Enterprise Monitor 8.0 Manual
Related Documentation Download this Manual
PDF (US Ltr)- 6.1Mb
PDF (A4)- 6.1Mb


15.3.1 Adding a MySQL Instance

This section describes how to monitor a MySQL instance.

Connection Settings

The Connection Settings tab

Figure 15.1 Add Instance Connection Settings

Content is described in the surrounding text.

Table 15.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 anInstance Addressof 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 AddressandPort

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 UserandPassword

The root user, or user with the privileges defined inCreating the Admin Userand 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, seeSection 5.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 UserandPassword

Add a user name and password for the General User.

Limited UserandPassword

Add a user name and password for the Limited User.


Encryption Settings

Figure 15.2 Add Instance Encryption Settings

Content is described in the surrounding text.

Table 15.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

粘贴CA certificate's contents here.

Note

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


Advanced Settings

Figure 15.3 Add Instance Advanced Settings

Content is described in the surrounding text.

Table 15.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'smaster.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 theserver_uuidvariable if present, or generates a random new UUID

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

    Note

    Host Plus Datadircan 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 themysqldatabase. 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

所使用的连接超时,在毫秒,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 theServer Grouppermission set toRead-Only, at least.

To create new groups, you must have theNew Group Creationpermission set toAdminister.