I know that MongoDB has master-slave architecture and Cassandra has peer to peer architecture.

I didn't find any resources about Vertica's architecture.

Is that master slave or peer to peer?
Does Vertica cluster allow multi-read and multi-write?


There is no concept of Master in Vertica.

But there is the concept of Initiator - this node will be the node who receives the connection and will compute the query plan, divide the workload among the nodes and then gather the result sets and format the output.

As for the multi-read and multi-write. Vertica is fully ACID complaint, this articles will give you more info. https://my.vertica.com/docs/7.0.x/HTML/Content/Authoring/ConceptsGuide/Other/Transactions.htm

  • Thanks :) by multi-read i meant if we can divide connections and send to NODE 2 or NODE 3 – shyam rakhecha Sep 14 '17 at 4:55
  • Hy,Yes is possible as Vertica has Native Load Balancer (must setup on both sides Client and Server) – Up_One Sep 14 '17 at 6:33

As noted in another answer, a Vertica cluster doesn't have a single master but has an initiator node that manages an operation using multiple nodes.

Vertica can parallelize a load if the data is available to multiple nodes. Nothing's going to help you if the data you want only exists on one local file system, but if it's in a shared location, you can take advantage of that. See the documentation of the COPY parameters "ON ALL NODES" and ON NODE {node-set}" -- guide, reference.

While you might not want to write your own data-loading extensions, you might also find the UDx documentation on load-parallelism interesting.

  • so if i do COPY t FROM 'file1.txt' ON (v_vmart_node0001, v_vmart_node0002); so data will be inserted only on node01 and node02 but not on node03 ?? – shyam rakhecha Sep 15 '17 at 6:40
  • @shyamrakhecha once data is in Vertica it's visible on all nodes. What that statement means is that node1 and node2 will be the only nodes that participate in the load operation. – Monica Cellio Sep 15 '17 at 14:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.