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
+2Hello 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
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
Thank you 4 your kind answer mosheg & sergeb.
Regards
Frank
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
