Multiple MySQL Servers

jerryau · 05-31-2006, 11:10 PM

Hello,

I'm trying to run version 4.x and 5.x servers on the same Fedora Core 5 box. My my.cnf file looks like this:

Quote:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
old_passwords=1

[mysqld0]
datadir=/var/lib/mysql4
socket=/var/lib/mysql4/mysql.sock
port=3307
basedir=/usr/share/mysql4

When I enter the command "service mysqld start" only the already preinstalled MySQL 5.x server starts up. What am I doing wrong here? Can anyone please explain to me, how to correctly setup and run such setup? I have seen the example file in the MySQL manual, but I have no idea how to make it work for me. Please help me.

Thanks,
Jerry

zeitounator · 06-01-2006, 12:43 AM

As a starter, I will point you to a thread where we recently discussed the same kind of problem.

http://www.linuxquestions.org/questi...d.php?t=449907

Now anyway: "service mysqld start" will only start one server, unless you modify yourself the /etc/init.d/mysqld script to start both of them. It would be better in my opinion to make a second script /etc/init.d/mysqld4 that you would then be able to run using "service mysqld4 start"

jtshaw · 06-01-2006, 12:55 AM

Please do not post the same thread in more than one forum. Picking the most relevant forum and posting it once there makes it easier for other members to help you and keeps the discussion all in one place.

http://www.linuxquestions.org/rules.php

Continue this thread here.