From: Date: June 16 2006 7:06pm
Subject: Re: cluster load balancer
List-Archive: http://lists.mysql.com/cluster/3725
Message-Id: <4492E51D.2020800@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi Saul,

Saul Waizer wrote:
..
> Can anyone point me in the right direction to setup load balancers or round
> robin dns for my application in order to get the true potential of the
> cluster. Right now I have 2 storage nodes and a management node, the
> application connects to node1, so if it goes down, it all goes down as well.

You have 2 data nodes. The API/MySQL nodes (the applications) will connect 
in a round robin way to the data nodes. You actually don't have to do 
anything in regards to 'load balancing' there. This is the whole point of 
Cluster where you can have 1 node failing, the other will continue working 
and keep the data, the cluster up.

Where you could load-balance is when you have multiple MySQL servers for 
example. Then you use something like LVS to use a round robin method to 
connect to the MySQL servers.

Hope this helps.

Geert

-- 
Geert Vanderkelen, Support Engineer
MySQL GmbH, Germany, www.mysql.com

Hauptsitz: MySQL GmbH, Radlkoferstr. 2, D-81373 München
Geschäftsführer: Hans von Bell, Kaj Arnö - HRB München 162140