Vertica cluster question

Goldengate

Hi guys hope you're doing great! please in other clusters setup (not Vertica ones) I've seen a cluster IP where all clients connect for HA, balancing among other things, but in Vertica how is this acomplished? because mostly I've see only the nodes' IP addresses and my second question is: which IP should use our devs? because if they use the IP address of the first node in their ETLs if the node goes down then the ETLs won't run.

Thx!

Frank

mosheg

Hello Frank,

You can define CLASSIC CONNECTION Load Balancing as the client libraries include a failover feature that allow them to connect to backup hosts if the host specified in the connection properties is unreachable.
Note that when using NATIVE CONNECTION load balancing, this failover feature is only used for the initial connection to the database.
If the host to which the client was redirected does not respond to the client's connection request, the client does not attempt to connect to a backup host and instead returns a connection error to the user.
See: https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/ConnectionLoadBalancing.htm

SergeB

To add to Moshe's answer, most clients also support providing a BackUpServerNode(s) should the first node be unavailable in the first place.
For instance for JDBC Driver: https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/ConnectingToVertica/ClientJDBC/JDBCConnectionProperties.htm?zoom_highlight=BackupServernode

Goldengate

Thank you 4 your kind answer mosheg & sergeb.

Regards

Frank