Skip to main content

Vertica DR

  • Jan 31, 2019 7:55 PM UTC
  • 4 replies
  • 10 views

sreeblr
Forum|alt.badge.img+2

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

4 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Jan 31, 2019 10:11 PM UTC

siddyash
Forum|alt.badge.img
  • Participating Frequently
  • Feb 1, 2019 5:23 PM UTC

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
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Feb 14, 2019 7:14 PM UTC

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


sreeblr
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Feb 21, 2019 2:09 PM UTC

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