Skip to main content

initiator node and load_balancing

  • April 6, 2014
  • 3 replies
  • 12 views
Navin_C
Forum|alt.badge.img+2
Hello All,

I have implemented load_balancing in our Vertica Cluster.

Now what I want to understand is, If my application is connected to one node of vertica, then is it that the initiator node will get all the request and then distribute the request to another nodes according to connection load balancing.
Or the connection are automatically hitting different nodes of vertica on the fly without going through initiator node because of connection Load balancing.

The issue is I am seeing a lot of query count on my initiator nodes.

Thanks




    3 replies

    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Author
    • Participating Frequently
    • April 6, 2014
    Hi Abhishek,

    You are describing about HP Vertica Load balancer IPVS package .

    My question is intended for Connection load balance feature included in Vertica 7.
    Which is implemented on Client side and server side to take place.

    Thanks
    deb0687
    Forum|alt.badge.img+1
    • deb0687
    • Participating Frequently
    • November 5, 2015

    Hi Naveen ,

     

    Have you got the solution for this ?

     

    I am facing the same issue regarding load balancing

     

    Below is the sql and the output .

    select  node_name,count(*) from query_requests group by 1;

    node_name                count
    v_pmdb_node0001    77895
    v_pmdb_node0002    2393
    v_pmdb_node0003    15

     
    I have set the load balance policy to roundrobin and ksafe 1 with 3 nodes

     
    Can you tell me why the load is not distributed and what all I need to do further

    opper20
    Forum|alt.badge.img+1
    • opper20
    • Participating Frequently
    • April 20, 2018

    Deb/Navin, Any solution on this on load not distributing?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement