How can I run Multiple MySQL Servers on a Single Computer?
Newsletters older than 6 months may have links that are out of date.
Please use the Search to check for updated links.
How can I run Multiple MySQL Servers on a Single Computer?
It is possible to run several MySQL servers on the same machine, provided that they don't work with same data. Each mysqld should have its own data directory.
With respect to the fact that some RAM is needed by the operating system itself, each MySQL server instance needs something like 100MB. Of course the rule with RAM is: "The more the better."
The requirements also depend greatly on the load of each instance. Even a single MySQL instance can comsume many resources if it is heavily used. If there is no heavy usage, you can easily run 10 separate MySQL instances on the same machine.
You can read more about running multiple servers on one computer in the MySQL documentation at
http://www.mysql.com/doc/en/Multiple_servers.html (http://www.mysql.com/doc/en/Multiple_servers.html)
© 2010, Oracle Corporation and/or its affiliates