5.4.4. MySQL Instance Manager Configuration Files
Instance Manager uses the standard my.cnf
file. It uses the [manager] section to read
options for itself and the [mysqld]
sections to create instances. The [manager]
section contains any of the options listed in
Section 5.4.3, “MySQL Instance Manager Command Options”. Here is an
example [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 the
/etc/my.cnf file only on Unix. On
Windows, MySQL Instance Manager reads the
my.ini file in the directory where
Instance Manager is installed. The default option file
location can be changed with the
--defaults-file=file_name
option.
Instance sections specify options given to each instance at
startup. These are mainly common MySQL server options, but
there are some IM-specific options:
-
mysqld-path =
path
The pathname to the mysqld server
binary.
-
shutdown-delay =
seconds
The number of seconds IM should wait for the instance to
shut down. The default value is 35 seconds. After the
delay expires, the IM assumes that the instance is hanging
and attempts to terminate it. If you use
InnoDB with large tables, you should
increase this value.
-
nonguarded
This option should be specified if you want to disable IM
monitoring functionality for a certain instance.
Here are some sample instance sections:
[mysqld]
mysqld-path=/usr/local/mysql/libexec/mysqld
socket=/tmp/mysql.sock
port=3307
server_id=1
skip-stack-trace
core-file
skip-bdb
log-bin
log-error
log=mylog
log-slow-queries
[mysqld2]
nonguarded
port=3308
server_id=2
mysqld-path= /home/cps/mysql/trees/mysql-5.1/sql/mysqld
socket = /tmp/mysql.sock5
pid-file = /tmp/hostname.pid5
datadir= /home/cps/mysql_data/data_dir1
language=/home/cps/mysql/trees/mysql-5.1/sql/share/english
log-bin
log=/tmp/fordel.log
