Options

How to recover changed data after one node fail?

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?

Comments

  • Options
     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 !  

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file