Re: I would like some information about load balancing

[Alex Davies]

Romain wrote:
> Yes, I want to use MySQL Cluster with Web apps
> (php script).
> But I thought that my webserver apache could
> connect to any of mysql cluster node and if the
> node is so busy it can redirect the query to
> another node. Doesn't MySQL Cluster provide me
> this functionality?

There are two different loads:
(a) Spreading the load around SQL noes ("API" in old terms). This is best done in my view with a loadbalancer, or RRDNS if you can't afford a Loadbalancer.

(b) Spreading the queries around storage nodes. MySQL cluster does this itself. You do not need to worry about this.

Alex

Alex Davies
http://www.davz.net | [e-mail]