Run 2 MYSQL instances on single PC without accidents

[Guest_imported]

Problem:

We can start up 2 mySQL instances on 2 different ports. However, when the shutdown command, regardless, of the port or socket defined in the input parameter, it will shutdown one of the database indiscriminately.

Objective:

To find a way to prevent this and to allow the shutdown command to shutdown the correct database.

 

[piti]

hi
depends on how you stop and start your mysql
if you are using the startup scripts, the startup script uses the pid file to kill the server
i would start experiment with this feature - create two startup scripts (one for each instance of mysql) and set there the pid file parameter (e.g. /var/run/mysql_1.pid and /var/run/mysql_2.pid)- when stopping one server the other one should be safe - well i hope so ;-)