Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

Possible Duplicate:
Can you help me with my capacity planning?

I am setting up a Load balancer with two backend webservers and one backend mysql server.

Is it a good idea to have dedicated mysql server ? or will it impact sql queries?

all the servers are running in one cloud zone and the latency between servers is less than 1ms

Thanks Sandeep

share|improve this question

marked as duplicate by MDMarra, Bart De Vos, Khaled, voretaq7 Jul 27 '12 at 20:11

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Extra power won't hurt you, generally speaking. This question, however, can't be answered in its current format. We need more detail. – Bart De Vos May 16 '12 at 7:05

If you go with a reliable provider then for starters you can go with a single provider and diversify later. Suggestion, benchmark your setup, the cost might not justify having a dedicated mysql server from the start.

Also explore weighted round robin load balancing algorithm, might be a good idea to send lesser than 50% traffic to the server which has the mysql+web app.

share|improve this answer

It's a good idea to build it, profile it, try a different build and profile that. These days, with virtual server environments and no hardware costs, it's significantly easier to try different infrastructure layouts before you go live.

So, try both, and see which is better under your anticipated load.

As the comments suggest, start simple, baseline performance under known load, and then add complexity as required to meet demand.

share|improve this answer
that works fine so far... I have this setup configured for a test site. I am also considering to have webservers on different cloud zone to avoid the SPOF but that will surely decrease mysql queries because the latency time will increase – sandeep.s85 May 15 '12 at 13:57
how are the other companies running their setups I've seen hosting companies runing a separate mysql server other than web server – sandeep.s85 May 15 '12 at 13:59
Most "other companies" started with a simple setup without any redunandancy, load balancing etc. They gradually improved their setup so they could meet their requirements. – Oliver May 15 '12 at 15:22
+1 on Oliver's comment, start simple, get it working and then add the other elements! – Mark Hillick May 15 '12 at 16:01

Not the answer you're looking for? Browse other questions tagged or ask your own question.