Skip navigation links

Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140

Contact Us Online »

MySQL Newsletter - Subscribe Today!

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