multiple mysql instances

[dimo1234]

I like to install two mysql instances using 4.0.24 in directory /usr/bin/mysql-4.0.24 (port 3306) and using 4.1.11 in directory /usr/bin/mysql-4.1.11 (port 3307). Both are running well, but only one at time. Both have different data directories and different directories for the immodb files.

I am using mysqld_multi and have change /etc.my.cnf using a group [mysqld2], but it doesn't work.

How has a configuration to look like and what is the best way to start the second instance?

 

[ericbrunson]

What happens when you try to start the second instance? Error messages?

 

[dimo1234]

it depends ...

when using unchanged "./mysqld_multi start 2" I got:

FATAL ERROR: Tried to start mysqld under group [mysqld2], but no mysqld binary was found.
Please add "mysqld=..." in group [mysqld_multi], or add it to group [mysqld2] separately.

although in the group [mysqld2] I had defined the correct mysqld.

When using "./mysqld_multi --mysqld=/usr/bin/mysql-4.1.11/bin/mysqld start 2" I don't get any message, but also nothing happens. No new processes have been start.