You really need different config files if you're going to log anything or if you need different server ids. You should also use different sockets. You can stop a specific server by specifying the host on the mysqladmin shutdown command.
I did it by keeping everything different, including the names of the my.cnf files, so it would be easy to distinguish the servers in a "ps -ef" command. On Fri, Aug 22, 2008 at 3:55 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > I am asking a very simple question. > > I need to install two mysql service (instances) on the same server. > I know we can do that using different port, but should i use two different > my.cnf files, and also, what is the procedure to stop one mysql service and > keep other one running. > > regards > anandkl > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
