Multiple MySQL server installations on one machine

[DeepDiverMom]

First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.)

If so, what naming convention (and infrastructure) distinquishes between the two MySQL servers? What network connectivity file entries would exist to differentiate between the two servers such that I could connect to one or the other servers from a remote client?

Thanks,

Becca

 

[TonyGroves]

You can certainly install two MySQL servers on the one machine. It's described in the manual:

http://dev.mysql.com/doc/mysql/en/multiple-servers.html