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,