C.2.2 MySQL Server (agent-instance.ini) Configuration

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.

user     = agent
password = somepass
hostname =
port     = 3306

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

Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb
User Comments
Sign Up Login You must be logged in to post a comment.