HA AND LOAD BALACING
I am working on load balancing now and have some doubt.
I have a 3 node cluster.
I did the load balacing step using the java code ConnectionLoadBalancingExample.java present in
and its working also.
[root@shrdevesx1 ~]# java -cp vertica-jdbc-7.0.2-1.jar:. ConnectionLoadBalancingExample
Connect attempt #1...Connected to node v_pmdb_node0001
Connect attempt #2...Connected to node v_pmdb_node0002
Connect attempt #3...Connected to node v_pmdb_node0003
Now my doubt is if I connect my squirrel client to node1 and lets say node1 is down then how I can execute my sql from node1 which in the backend will be connected to node2 or node3.
How load balacing is connected to High availability.
Please claify my doubt.