Skip to main content

How to recover changed data after one node fail?

  • May 23, 2014
  • 1 reply
  • 9 views

Hyun

For instance, I have 3 vertica nodes and k-safe=1.

At once node 2 was crashed while transaction processing.

Transaction would be OK continously.

1 hour later, node 2 was repaired and it's OS and database started.

My question is;

1. does node 2 database recover only changed information or all information from other nodes?

2. If recovery would be processing only changed information, where does this information stored?

1 reply

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • May 23, 2014
 Node 2 will be recovered to the point where the data was consistent on all nodes. 
Your cluster will be brought back to the LGE(Last good epoch), any data change after that LGE will be lost(as it was inconsistent).
 I am not sure what you mean about the fact that recovery will process only changed info !