Load balancer best option

Moderator: NorbertKrupa

Post Reply
sowe
Newbie
Newbie
Posts: 11
Joined: Thu Jul 02, 2015 8:43 pm

Load balancer best option

Post by sowe » Fri Dec 11, 2015 9:38 pm

Hi all,
I've a cluster with 3 nodes. I want to install a load balancer in this cluster. I'm thinking using HAproxy or a round robin DNS but i don't know if exist a best option. any recomendation or solution?
Thanks

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1768
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Load balancer best option

Post by JimKnicely » Fri Dec 11, 2015 9:41 pm

I've had alot of success with Vertica's "Native Connection Load Balancing"

Check out:
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

sowe
Newbie
Newbie
Posts: 11
Joined: Thu Jul 02, 2015 8:43 pm

Re: Load balancer best option

Post by sowe » Fri Dec 11, 2015 9:52 pm

Thanks i'll try thanks

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Load balancer best option

Post by NorbertKrupa » Sat Dec 12, 2015 11:28 pm

The piece that's usually forgotten is that the client side must also request a load balanced connection for this to work!
Checkout vertica.tips for more Vertica resources.

sowe
Newbie
Newbie
Posts: 11
Joined: Thu Jul 02, 2015 8:43 pm

Re: Load balancer best option

Post by sowe » Sun Dec 13, 2015 11:25 am

NorbertKrupa wrote:The piece that's usually forgotten is that the client side must also request a load balanced connection for this to work!

Sorry but understood this part , exist a spatial parameter in jdbc or psql connection ?? or .... ?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Load balancer best option

Post by NorbertKrupa » Sun Dec 13, 2015 4:17 pm

That's correct. See the documentation for client side connection parameters.
Checkout vertica.tips for more Vertica resources.

sowe
Newbie
Newbie
Posts: 11
Joined: Thu Jul 02, 2015 8:43 pm

Re: Load balancer best option

Post by sowe » Mon Dec 14, 2015 1:18 pm

done thanks for all
NorbertKrupa wrote:That's correct. See the documentation for client side connection parameters.

Post Reply

Return to “Vertica Installation”