How to use F5 hardware load balancing with Vertica cluster?

Moderator: NorbertKrupa

Post Reply
darko86
Newbie
Newbie
Posts: 1
Joined: Wed Jun 21, 2017 2:48 pm

How to use F5 hardware load balancing with Vertica cluster?

Post by darko86 » Wed Jun 21, 2017 2:51 pm

Hi Guys,

I was wonder if any of you used F5 load balancing with Vertica cluster of 3 nodes? I will appreciate if you can share some information about it.

Thanks :)

RafZx2
Newbie
Newbie
Posts: 1
Joined: Tue Oct 17, 2017 9:09 pm

Re: How to use F5 hardware load balancing with Vertica cluster?

Post by RafZx2 » Tue Oct 17, 2017 9:48 pm

Hello darko86,

I never used a F5 to balance a Vertica cluster, but I used Zevenet to balance/HA my connections to the cluster.

Why I use Zevenet?
Because the customer has a 6.1 Vertica version and Zevenet has a community edition. If you are using version 7 or above, Vertica has function to HA/Balance the cluster thru the ODBC/JDBC connection, take a seat and read this link: https://my.vertica.com/docs/8.1.x/HTML/ ... g%7C_____1

To setup the Zevenet, first I create a VIP and the server farm above.

VIP - 10.0.8.39:5433

Vertica Farm -
Node 1 - 10.0.8.211:5433
Node 2 - 10.0.8.212:5433
Node 3 - 10.0.8.213:5433

All requests thru the IP 10.0.8.39 and port 5433 are balanced in the server farm, round robin.

After that I setup a Check_TCP to check Vertica database port every 30 seconds, If the tcp_check fails they put the node out until the tcp_check get an OK result.

You must have more experience than me, I believe it's the same logic in F5.

PtC - F5 box throughput limit... If you transfer a lot of data to the cluster thru the F5 you can handle some problems in your network if reach the box limit.

I think its can help, better late than never, cheers!

Post Reply

Return to “Vertica Database Administration”