The Teradata Hot Standby Node Explained | DWHPRO

Teradata Hot Standby Node Explained

A hot standby node is a member of a group of nodes (clique) and there are no virtual processes running on it (AMPs, Parsing Engines).

The hot standby node waits for its mission, which takes place when a node crashes out of its clique.

Then all the AMPs of the crashed node are immediately migrated to the hot standby node. This happens practically without any loss of performance:

Node crashes, migration of AMPs takes place

The ingenious thing about the design is the following: As soon as the crashed node is online again, it becomes the new hot standby node:

Recovered Node becomes the new HSN
What I Wish Everyone Knew About The Parallel Teradata Design
Teradata Architecture Is So Famous, But Why?
DWH Pro Admin