Easily manage multiple MySQL instances with instance Manager

One, the MySQL database instance Manager Overview:

1, the MySQL database instance Manager (IM) is through the TCP/IP port running background program, used to monitor and manage the MySQL database server instance.

2, if im hanging, then all the instances will be hung; If the instance hangs, Im will try to start it again.

3, IM reading configuration files such as MY.CNF [manager] section.

4. The example in this article is based on the Linux environment test.

Second, the configuration note:

1, the configuration file is as follows:

[manager]

user=mysql

default-mysqld-path = /usr/local/mysql/bin/mysqld

socket=/tmp/manager.sock

pid-file=/tmp/manager.pid

password-file = /etc/mysqlmanager.passwd

monitoring-interval = 2

port = 1999

bind-address = 192.168.0.231

log = /usr/local/mysql/bin/mysqlmanager.log

run-as-service = true

[mysqld1]

...

[mysqld2]

...

This has two configuration instances, specifically do not say. See my article for installing multiple instances.

See Mysqlmanager--help for specific meanings