Replace a Node Using an Active Standby Node

Note: A node must be down for Vertica before you can replace it with an active standby node. If you attempt to replace a functioning node, Vertica displays an error message.

Replacing a Node with Automatic Failover

Vertica can automatically replace a failed node with an active standby node. In the General Parameters configure the FailoverToStandbyAfter parameter to allow automatic failover.

Manually Replacing a Node

  1. Connect to the database with Administration Tools or vsql.
  2. Enter the command: ALTER NODE node-name REPLACE WITH standby-node-name;