Skip to main content

3 node cluster

  • June 22, 2015
  • 1 reply
  • 4 views
deb0687
Forum|alt.badge.img+1

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

    1 reply

    Rahul_Choudhary
    Forum|alt.badge.img
    • Rahul_Choudhary
    • Participating Frequently
    • June 22, 2015

    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

     

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement