Vertica DR

sreeblr

How can we replicate real time to another DR location ,is there any other mechanism to be able to bring up vertica very fast/near realtime at a DR site

Jim_Knicely

Are you looking to replicate schemas and objects (i.e. tables)?

See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm

siddyash

If you want to use a 3rd Party Tool, try using Attunity CDC option. However, every table should have a primary key and an timestamp column. We are currently exploring the option and are hoping to publish a document once completed.

sreeblr

Hi Jim , Will steps listed in link that you sent work for Vertica 9.1 ?

sreeblr

Can we have 6 node system with ksafe 1 and 3 nodes in each Data Centre to have 99% availability. Will it have impact performance