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

[chaim.rieger@xxxxxxxxx]

Right

Keep them in the datadir to make things easier for you


Sent via BlackBerry from T-Mobile

-----Original Message-----
From: "Ananda Kumar" <anandkl@xxxxxxxxx>

Date: Sun, 24 Aug 2008 23:47:24 
To: Jim Lyons<jlyons4435@xxxxxxxxx>
Cc: mysql<mysql@xxxxxxxxxxxxxxx>
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 <anandkl@xxxxxxxxx> 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 <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
>>
>>
>
>