Run multiple MySQL server on a single machine

Question

Can we run multiple MySQL servers on a single machine?

Thanks.

Answer 1

Yes, you just need to run them on separate ports and point them at different lib directories for their data.

Here's a good reference: http://dev.mysql.com/doc/refman/5.1/en/mutiple-servers.html

(If you want to use this for testing, I suggest checking out MySQL Sandbox @ https://launchpad.net/mysql-sandbox)