***BOGO*** Re: multiple mysql service on the same server

["Ananda Kumar" <anandkl@xxxxxxxxx>]

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 <jlyons4435@xxxxxxxxx> 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 <anandkl@xxxxxxxxx> 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
>
>