Skip to main content

Vertica DR

  • January 31, 2019
  • 4 replies
  • 4 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
    • Jim_Knicely
    • Participating Frequently
    • January 31, 2019

    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
    Forum|alt.badge.img
    • siddyash
    • Participating Frequently
    • February 1, 2019

    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
    • sreeblr
    • Author
    • Participating Frequently
    • February 14, 2019

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

    sreeblr
    Forum|alt.badge.img+2
    • sreeblr
    • Author
    • Participating Frequently
    • February 21, 2019

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement