Home / server / Questions / 389242
In Process
sandeep.s85
Asked: 2012-05-16 05:29:37 +0800 CST

load balancer topology [duplicate]

  • 772

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

load-balancing

2 Answers

  1. 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.

    • 1

  2. 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.

    • 0