Re: I would like some information about load balancing

[Romain]

Alex Davies wrote:
> Romain wrote:
> > with mysql cluster?... What do you use to do
> load
> > balancing of mysql queries?
>
> Right. Typical setup:
>
> 1X Loadbalancer forwarding requests to
> 2X API Nodes with apache and the PHP scripts
> connecting to "localhost". API nodes connected to
> 2X Storage nodes
>
> You don't have to loadbalance SQL. Loadbalance
> your web requests (easy to do) and use local SQL
> nodes.
In fact, my MySQL and apache server aren't the same server. I have an apache cluster which is working with LVS clustering system. And I wonder if I can use lvs to do an other cluster with only MySQL server.
Finally a PHP scripts could tell the MySQL loadbalancer and the loadbalancer redirect the mysql query to the mysql server which works the least.
I think it's possible but I would like some opinion of this solution and if it's performant ;)

>
> Alex
>
Romain,
I hope that you can understand my messages...