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 mysqld-instance-dir
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 user option.
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-ms option 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.ini
configuration file and add the line:
socket = /full/path/to/mysql.sock
inventory-schema: If your system
configuration does not allow creating tables inside the
mysql schema, specify another schema to
hold the inventory table that records the server UUID:
inventory-schema = schema_name
Replication topology
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 Agent can then match the slave and master in the
replication topology.
agent-master-uuid-discovery: To switch off
the use of the master UUID entirely when determining the
replication topology, see also
agent-master-uuid-discovery
option.
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.