Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_24.2/page/index.html

client-connection-failover-and-load-balancing.md

The Load balancer does not redirect to a host where the host primary address is down. However, it may still redirect to a host whose export address is not available. In such cases, when the BackupServerNode connection parameter is provided:

  1. The clients attempt to establish a new connection using the backup hosts.
  2. The server treats this as a new connection request.
  3. This new connection is again subject to load balancing.
  4. As load balancing is not preserved globally across initiator nodes, a retry through the backup host still redirects to the same export address that is not reachable.

The BackupServerNode connection parameter does not prevent failures that are caused by load-balanced targets that are not reachable.