3 node cluster

deb0687

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

Rahul_Choudhary

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