This section provides reference information about the
agent-instance.ini configuration file,
supplementing the usage information in
Section 5.3, “Monitor Agent Installation”.
For each MySQL server that you want to monitor, create an
agent-instance.ini file in the directory
specified by the
configuration parameter inside the main
mysql-monitor-agent.ini file. This file
contains the host name and user credentials for connecting to the
MySQL server to monitor. The format of the file is as follows:
# To use this .ini file as a template for configuring additional # instances to monitor, do not simply copy and re-start the agent # without first modifying the parameters below to match the login # credentials for the new instance. # # Refer to the documentation for more detailed information and # instructions. [mysqld] user = agent password = somepass hostname = 127.0.0.1 port = 3306 [replication] discovery-username = agentdiscovery discovery-password = password
The individual configuration parameters can be defined as follows, as either a [replication] or [mysqld] option.
hostname: The host name of the MySQL server to monitor.
port: The TCP/IP port of the MySQL server to monitor.
user: The user ID that connects to the MySQL server to monitor.
password: The password for the user ID specified by the
connection-init-retry-attempts: The number of times to retry when the initial connection to the monitored MySQL server fails. The default is 10. Do not specify this option and the following
connection-init-retry-delay-msoption are only needed if some combination of database load and network traffic cause intermittent connection failures for the Agent, and you need to increase the default values.
connection-init-retry-delay-ms: The number of milliseconds to wait before trying again after a connection failure.
socket: To configure the agent to use sockets, during installation, select “socket” rather than “TCP/IP” from the menu, then specify the socket name. To switch to a socket connection after installation, edit the
agent-instance.iniconfiguration file and add the line:
inventory-schema: If your system configuration does not allow creating tables inside the
mysqlschema, specify another schema to hold the inventory table that records the server UUID:
discovery for an instance is determined by the agent using the
master.info file for the instance, extracting
the username/password to connect to the master, and then
retrieving the MySQL Enterprise Monitor generated
UUID of the replication master.
The MySQL Enterprise Monitor Agent can then match the slave and master in the
agent-master-uuid-discovery: To switch off the use of the master UUID entirely when determining the replication topology, see also
discovery-password: Alternative password used for retrieving the master UUID.
discovery-username: Alternative username used for retrieving the master UUID.
master-info-file: A file path to the
master.info, that will override the value in the database.