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/fr/mysqld-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/en/instance-manager-command-options.html
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
