Vertica Cluster Q

Keng_Heng__Chan

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

 

Adrian_Oprea_1

 

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