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!

Vertica Cluster Q

Hi, I would to know more how vertica cluster work.

a) Do I need to have a connection load balancer in front of vertica cluster?

b) If I submit a select query to node 1, will the query run over the other Node 2, 3.. nth

c) If do a bulk copy on Node 1, it will only using Node 1 resources to perform the load ?

d) Any documentation or paper I can refer how the vertica cluster work ?

 

Thanks,

KH. Chan

 

Comments

  •  

    a) Do I need to have a connection load balancer in front of vertica cluster?

    - Vertica has native load balancer buildin , it comes disabled by default, you will have to enable it and also your client (ODBC prop).

    - You can also put a LB in front of Vertica(maybe a better idea), why a better idea? - Vertica LB is Round robin so if any node is down he won't avoind the down node so some connections will fail :(.

     

    b) If I submit a select query to node 1, will the query run over the other Node 2, 3.. nth

    Yes , that is the idea, but you need to have your projections in place allover your nodes.

     

    c) If do a bulk copy on Node 1, it will only using Node 1 resources to perform the load ?

     Depends on the copy options

     

    d) Any documentation or paper I can refer how the vertica cluster work ?

     This is the official doc

    https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConceptsGuide/Other/HP_Vertica_Documentation.htm

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file