Skip to main content
Question

skip recovery on replica cluster

  • October 22, 2019
  • 3 replies
  • 15 views

phil2
Forum|alt.badge.img+2
  • Participating Frequently

Hello!
I have two vertica clusters - one as a master and one as a replica. Eventually one of the replica hosts goes down, and I need to replace it. So I run alter node replace with a standby on replica. It goes thru a full recovery and copies data from buddies. After that I run vbr. It sees that all the data on host changed and copies all the data again from master. Is it possible to skip recovery on replica cluster or somehow make it replication-aware so vertica wont copy the same data twice?

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • October 22, 2019

Vertica copies whole data only on first replication. On subsequent replications, it will just replicate the data which has changed/newly added. Please visit the following link for more information.

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


phil2
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 22, 2019

It does not work if you recover one node on replica cluster. It cannot detect delta after recovery as the original files and original epochs get lost during recovery.


Thakur
Forum|alt.badge.img
  • Participating Frequently
  • November 8, 2019

copy cluster works differently than replication, incase of copycluster target is down while in replication both clusters are up.
Recovery in copycluster can be skipped as @Sharon_Cutter mentioned but not in replication. Even though the underlying data is same, newly recovered node has new rosid as compared to the past from source.