Master/Slave or Master/Master Replication

[janice]

Hi,

I'm just starting to learn about back up strategies for Vertica. Is there any type of master/slave or master/master replication for Vertica? If not, If we have two parallel clusters is it best to just write ETL to both or to one and then copy the data from it to the other (for fail over purposes).

Thanks!

[id10t]

Vertica to Vertica - is a better solution since no data validation and data can be compressed.

[nnani]

JANICE,

Vertica allows you to take backup in 3 ways
1. Cluster with n nodes to SAN
2. Cluster with n nodes to Cluster with m nodes
3. Cluster with n nodes to Cluster with n nodes.

additionally VERTICA provides you with the BACKUP script called as vbr.py( python script) wich can easily help you to take backups.
All you need to do is put correct values to all parameters in the vbr.py.