Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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.

Answers

  • @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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.