A loadbalancer is used in many MySQL setups. Loadbalancing can be
done with an hardware loadbalancer or with software. Software
solutions tend to be a fair bit cheaper.
Loadbalancing is often implemented as an extra layer: The
application connects to the loadbalancer via the network and the
loadbalancer connects to the database via the network. The
loadbalancing can be implemented on the application machines to
get rid of the extra layer, this is better for latency (each
layer adds latency) and as each application server has it's own
loadbalancer it can also remove bottlenecks. The drawback are
that you'll lose a single point of control and with multiple
loadbalancers the number of health check queries will probably
increase. The two-layer setup is often used with Connector/J and
haproxy.
There are simple and more intelligent loadbalancers. There are
loadbalancers which can split read and write traffic for example.
Of …
Showing entries 1 to 1
Sep
07
2013
Showing entries 1 to 1