Hello, Has anyone had success deploying Avatica behind a load balancer? If so, are there any recommended best practices for binding client requests to a particular Avatica server? As one might expect, the simple round-robin load balancer I am using is routing requests to servers that are unaware of the request state so most queries are failing.
I am also interested in exploring the possibility of "sessionless" requests in Avatica. I see CALCITE-668 <https://issues.apache.org/jira/browse/CALCITE-668?jql=text%20~%20%22avatica%20load%20balancer%22#:~:text=Calcite-,CALCITE%2D668,-%5BAvatica%5D%20Support%20sessionless> was raised in 2015 to discuss such work but it doesn't seem to have had much traction. Several ideas come to mind including passing the complete session state in each request or allowing for pluggable state providers to track the request state between nodes. Anyone care to share their experiences of running Avatica behind a load balancer or thoughts on what a "sessionless" service might look like? Best, -- TJ