Page 1 of 1
Load balancer best option
Posted: Fri Dec 11, 2015 9:38 pm
by sowe
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
Re: Load balancer best option
Posted: Fri Dec 11, 2015 9:41 pm
by JimKnicely
I've had alot of success with Vertica's "Native Connection Load Balancing"
Check out:
Re: Load balancer best option
Posted: Fri Dec 11, 2015 9:52 pm
by sowe
Thanks i'll try thanks
Re: Load balancer best option
Posted: Sat Dec 12, 2015 11:28 pm
by NorbertKrupa
The piece that's usually forgotten is that the client side must also request a load balanced connection for this to work!
Re: Load balancer best option
Posted: Sun Dec 13, 2015 11:25 am
by sowe
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 .... ?
Re: Load balancer best option
Posted: Sun Dec 13, 2015 4:17 pm
by NorbertKrupa
That's correct. See the documentation for client side connection parameters.
Re: Load balancer best option
Posted: Mon Dec 14, 2015 1:18 pm
by sowe
done thanks for all
NorbertKrupa wrote:That's correct. See the documentation for client side connection parameters.