Vertica Replication

Vertica Database Replication Concepts

Replication the Vertica process of storing identical copies of data across all nodes in a cluster.
Replication:

  • will offer H.A.(high availability) to our cluster by creating buddy projections across all nodes.
  • this way every node will have a copy of the other node projections enabling us to recover from a node loss.
  • Replication creates and stores identical copies of projections for small tables across all nodes in the cluster.

Replication is best used for a small projection, copy the full projection to each node.
Example :

In the image we can see that we have 4 projections that are replicated across all nodes.

   

I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click

clickhere

Similar Article  How to install and configure the AWS client
No Comments
Leave a Comment

%d bloggers like this: