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