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
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@stripped> 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.
Web developer / Database administrator