Client Load-balancing and Session Stickiness

[Jacques Nadeau <ja...@apache.org>]

Hey All,

I saw the comments on DRILL-4313 recently and wanted to understand how
people were thinking about session stickiness in the concept of client
query load balancing?

thanks,
Jacques

Re: Client Load-balancing and Session Stickiness

[Parth Chandra <pa...@apache.org>]

With a client connection pool, there is no good (and easy) way to provide
session stickiness.

We could try to introduce the idea of a cluster wide session, but that is
going to be hairy. Th other option, localizing it to a client is for the
client to maintain session settings and setting them explicitly for every
connection in the pool. Neither is ideal or, in my opinion, worth the
effort.

I've been running some experiments on whether connection pooling improves
query distribution (with Tableau) and I'll share those on the JIRA.

I don't think we should allow connection pooling as a default option ever,
unless the end user insists on it.

Parth

On Thu, Feb 18, 2016 at 9:48 AM, Jacques Nadeau <ja...@apache.org> wrote:

> Hey All,
>
> I saw the comments on DRILL-4313 recently and wanted to understand how
> people were thinking about session stickiness in the concept of client
> query load balancing?
>
> thanks,
> Jacques
>