This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Question
Vertica documentation (https://my.vertica.com/docs/7.1.x/PDF/HP_Vertica_7.1.x_ConnectingToHPVertica.pdf) mentions two Failover options:
· Using DNS Failover
· Using the Backup Host List
Answer
However, OpsA / OBA only supports the DNS Failover
DNS Failover: when Vertica connection is made to a hostname, the DNS needs to return a list of IPs, but the connection string doesn’t need to be changed to add backup nodes. When DNS returns a list of IPs, the driver will go through the list to find the first connectible nodes. Further information can be found in Vertica documentation: https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientJDBC/JDBCConnectionFailover.htm
Another option is to use Load Balancer on Vertica
Load Balancer: Native Load Balancing is one of the methods proposed by Vertica. It's like ODBC or JDBC driver, the customer could apply any other Load Balancer such as F5, Big IP and it should work.