MySQL Instance manager configuration file

Instance Manager uses standard MY.CNF files. It uses the [manager] section to read the options for itself and read the [MySQLd] section to create an instance. The [Manager] section contains the options listed above. The following is an example of the [Manager] section:

# MySQL Instance Manager options section
[manager]
default-mysqld-path = /usr/local/mysql/libexec/mysqld
socket=/tmp/manager.sock
pid-file=/tmp/manager.pid
password-file = /home/cps/.mysqlmanager.passwd
monitoring-interval = 2
port = 1999
bind-address = 192.168.1.5

The MySQL instance manager reads and manages/ETC/MY.CNF files only in Unix. In Windows, the MySQL instance manager reads My.ini files from the installation directory of Instance Manager. You can change the location of the default option file with the--defaults-file=file_ name option.

The instance section specifies the option to give each instance at startup. These are mostly common MySQL server options, but there are some im-specific options:

·mysqld-path = <path-to-mysqld-binary>

The path to the MYSQLD server binary.

·shutdown-delay = Seconds

The number of seconds that im should wait for the instance to shut down. The default is 35 seconds. After the delay time, IM assumes that the instance is pending and attempts to "kill–9" it. If you use a innodb with a large table, you should increase the value.

·nonguarded

If you want to disable IM monitoring for an instance, you should set this option.