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