Posted on

Do you know the MySQL Instance Manager

Do you know the MySQL Instance Manager?
The Instance Manager?
Yes, the Instance Manager.
Do you know the MySQL Instance Manager?
Which lives in MySQL 5.0 ?

(free adaptation of that horrid “Do you know the Muffin Man?” story)

MySQL Instance Manager (IM) is a daemon running on a TCP/IP port, which serves for monitoring and management of MySQL Database Server instances. MySQL Instance Manager is currently available for unix-like operating systems.

MySQL Instance Manager is included in MySQL distributions from version 5.0.3. MySQL Instance Manager can be used to start and stop the MySQL Server, even from a remote host, instead of the mysqld_safe script/

MySQL Instance Manager also implements the functionality (and most of the syntax) of the mysqld_multi script (used to run multiple MySQL servers on the same physical machine, for instance different versions of MySQL to maintain legacy applications).

For a detailed description of the MySQL Instance Manager, see http://dev.mysql.com/doc/mysql/en/instance-manager.html

Posted on