How to configure F5 (Network load balancing tool) with Vertica cluster?

akissay

Hello,
Has some one worked with F5 tool to make load balancing for Vertica cluster. I'm looking for the appropriate set up in F5 to check the health of the Vertica node (is Up & Running) before sending transaction to it.
Thank you in advance for your Help.

GoCougs

@akissay said:
Hello,
Has some one worked with F5 tool to make load balancing for Vertica cluster. I'm looking for the appropriate set up in F5 to check the health of the Vertica node (is Up & Running) before sending transaction to it.
Thank you in advance for your Help.

We've done this before but we moved to vertica load balancing. Have you considered using that? Vertica load balancing will check the health of the node. For example you can do this

Server side (Do Before Client Side)
On the vertica database, run the following command to activate load-balancing
SELECT SET_LOAD_BALANCE_POLICY('ROUNDROBIN');
This will allow the db to do LB.

Client Side
you can add the following to the connection url.
jdbc:vertica://node001:5433/vmart?connectionloadbalance=true&backupservernode=node002,node003