6 messages in com.mysql.lists.clusterRe: MySql Cluster Data Node Failure
FromSent OnAttachments
Waseem Azhar07 Jun 2007 07:09 
Waseem Azhar07 Jun 2007 07:14 
Jimmy Guerrero07 Jun 2007 07:25 
Jon Stephens07 Jun 2007 08:58 
Waseem Azhar08 Jun 2007 00:24 
Sebastien LELIEVRE08 Jun 2007 00:31 
Subject:Re: MySql Cluster Data Node Failure
From:Sebastien LELIEVRE (slel@tbs-internet.com)
Date:06/08/2007 12:31:05 AM
List:com.mysql.lists.cluster

Waseem Azhar a écrit :

Thank You. It was really helpful. I perfom a quick test and it worked.

I have another question, Does it make sense to have more than one Sql Nodes in a cluster. According to my understanding switching between sql nodes is not transparent to the client application.

It is, if you're using a load-balancing system.

Do i need handle it myself in my client application ? or is there any mechanism exists where if one sql-node goes down the other take up the charge and remain transparent to the client.

Look around the Linux HA Project (http://www.linux-ha.org/) and LVS

Cheers,