Hi List,

Though new to mysql server, I was pretty happy with what I was doing till I
needed to run another instance of mysql server on the same machine.

My first installation is running on port 3307 instead of default which I
achieved by adding a port attribute in /etc/my.cnf file. Rest of the
/etc/my.cnf file contains the basedir, data dir . logs and pid etc. Now I
need to install a second server running on 3306 and all different pid,
datadir paths etc...

When I install the second version giving all the enw paths to configure and
then run mysqld, it always say mysqld is already running. I have tried other
ways using the default-files option, changing the cnf file locations.... and
none if it working.

I will appreciate any pointers please!

Thanks

Naufal Sheikh a écrit :
> Hi List,
>
> Though new to mysql server, I was pretty happy with what I was doing till I
> needed to run another instance of mysql server on the same machine.
>
> My first installation is running on port 3307 instead of default which I
> achieved by adding a port attribute in /etc/my.cnf file. Rest of the
> /etc/my.cnf file contains the basedir, data dir . logs and pid etc. Now I
> need to install a second server running on 3306 and all different pid,
> datadir paths etc...
>
> When I install the second version giving all the enw paths to configure and
> then run mysqld, it always say mysqld is already running. I have tried other
> ways using the default-files option, changing the cnf file locations.... and
> none if it working.
>
> I will appreciate any pointers please!
>
> Thanks
>
Hi,
One of the best way to run multiple instance on the same box is by
using mysqld_multi.

I'll suggest looking at the doc for it :
http://dev.mysql.com/doc/refman/5.0/...qld-multi.html

Basically you need to redeclare the pid, datadir etc (looks at the
exemple). You'll probably need to work out a bit the init script for
your distribution too!

Another one is the instance manager for which I have no experience. The
documentation should provide the information needed however:
http://dev.mysql.com/doc/refman/5.0/...d-options.html

Regards,

--
Mathieu Bruneau
aka ROunofF

===
GPG keys available @ http://rounoff.darktech.org