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
How to use F5 hardware load balancing with Vertica cluster?
Moderator: NorbertKrupa
Re: How to use F5 hardware load balancing with Vertica cluster?
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!
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!