Right Keep them in the datadir to make things easier for you
Sent via BlackBerry from T-Mobile -----Original Message----- From: "Ananda Kumar" <[EMAIL PROTECTED]> Date: Sun, 24 Aug 2008 23:47:24 To: Jim Lyons<[EMAIL PROTECTED]> Cc: mysql<mysql@lists.mysql.com> Subject: Re: multiple mysql service on the same server Hi Jim, If i need to use different my.cnf file, they should be in different directory right. regards anandkl On 8/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > 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 >> >> > >