Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 superuser.com Nov 18 '10 at 17:46

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

add comment

3 Answers

Buy MySQL Cluster.

share|improve this answer
add comment

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
add comment

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
add comment

Your Answer

 
discard

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