The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
3 node cluster
Hi ,
I have a 3 node cluster having IP x.x.x.117,x.x.x.118,x.x.x.119.
1st I installed vertica in 117 and then updated in 118 & 119.
Now all the nodes are up & running.
Now our reporting tool is connected to 117.
If 117 will be down then still the DB is up & running but we can access from reporting tool.
How I can manage in this case ?
Note : we cannot change the IP again & again in tool as this is product.
Regards,
Deb
0
Comments
Hi
The resolution for your problem is "Load Balancing".Connection load balancing helps automatically spread the overhead caused by client connections across the cluster by having hosts redirect client connections to other hosts. By redirecting connections, the overhead from client connections is spread across the cluster without having to manually assign particular hosts to individual clients. Clients can connect to a small handful of hosts, and they are naturally redirected to other hosts in the cluster.
This will address your current question as well.
Please go though below documented vertica link for detailed information on this:
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/LoadBalancing/ConnectionLoadBalancing.htm%3FTocPath%3DAdministrator's%2520Guide%7CManaging%2520the%2520Database%7CConnection%2520Load%2520Balancing%7C_____0
Regards
Rahul Choudhary