Hi All, I did using single my.cnf file, by specifying different server groups, which allows for specifying different socket, pid and data directory structure. It can be managed by using mysqld_multi.
regards anandkl On 8/22/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > 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 > >