Skip navigation links
2.3.6.3 Monitoring Multiple MySQL Servers »
Section Navigation      [Toggle]

2.3.6.2. MySQL Server (agent-instance.ini) Configuration

For the MySQL server that you want to monitor, you must create an agent-instance.ini within the directory specified by the mysqld-instance-dir configuration parameter within the main mysql-monitor-agent.ini file.

The agent-instance.ini file contains the host name and user credentials for connecting to the MySQL server that you want the agent 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 start a new agent
# without first modifying the displayname.
#
# Refer to the documentation for more detailed information and
# instructions.
#
# Version: 20080718_230416_r7011

[mysqld]
hostname = 127.0.0.1
port     = 3306
user     = root
password =

The individual configuration parameters can be defined as follows:

  • hostname — the host name of the MySQL server that you want to monitor.

  • port — the TCP/IP port of the MySQL server that you want to monitor.

  • user — the user to use when connecting to the MySQL server that you want to monitor.

  • password — the corresponding password to use when connecting to the MySQL server that you want to monitor.

It is also possible to configure the agent to use sockets. This can be done during installation by selecting “socket” rather than “TCP/IP” from the menu and then specifying the socket name. This can also be configured after installation by editing the agent-instance.ini configuration file, and adding the line: 

socket = /full/path/to/mysql.sock