Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Now, I have a server running php + Mysql, but my server loading is very high, I want to start up one more server to reduce the workload, what should I do? Thank you.

share|improve this question

migrated from Nov 18 '10 at 17:46

This question came from our site for computer enthusiasts and power users.

You will probably need to do a lot of reading. Topics of particular interest include:

  • MySQL replication
  • Server load balancing
  • High availability (HA)

Google search for all for all of these (throw in "apache" or "mysql") will probably yield useful results. You will need to replicate your database data, and you will probably also want to replicate your static content between the two servers. You may also need to arrange for ip load balancing, either via something like round-robin DNS + high availability software (heartbeat/pacemaker/etc) or through the use of yet another system as a load balancer.

This google search yielded a variety of interesting documents:

share|improve this answer

Buy MySQL Cluster.

share|improve this answer

I don't want to be offtopic but... More horsepower to that pc?

Adding ram is easy and cheap and can do the trick...

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.