[ https://issues.apache.org/jira/browse/CALCITE-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706234#comment-17706234 ]
Vaibhav Joshi edited comment on CALCITE-5581 at 3/29/23 6:36 AM: ----------------------------------------------------------------- Thanks [~stoty] I have fixed CemelCase issue in my PR which you had suggested earlier. I checked the code and as per my analysis we can implement retries ( trying out different host) based on connection property. *LB_FAILOVER_RETRIES* Http connection timeout is little tricky. Is it okay if we use System property *"avatica.connection.timeout"* to override the default connection timeout ( current default is 3 minutes defined in RequestConfig.java)? was (Author: JIRAUSER291813): Thanks [~stoty] I have fixed CemelCase issue in my PR which you had suggested earlier. I checked the code and as per my analysis we can implement retries ( trying out different host) based on connection property. *LB_FAILOVER_RETRIES* Http connection timeout is little tricky. Is it okay if we use System property *"avatica.connection.timeout"* to override the default connection timeout ( current default is 3 minutes defined in RequestConfig.java). > Implement Basic client side load balancing in Avatica Driver > ------------------------------------------------------------ > > Key: CALCITE-5581 > URL: https://issues.apache.org/jira/browse/CALCITE-5581 > Project: Calcite > Issue Type: New Feature > Components: avatica > Affects Versions: 1.33.0 > Reporter: Vaibhav Joshi > Assignee: Vaibhav Joshi > Priority: Major > Labels: pull-request-available > Attachments: Avatica Basic client side load balancing.docx > > Time Spent: 1.5h > Remaining Estimate: 0h > > Implement mechanism to support Client side load balancing by configuring > connection properties for load balancing > {code:java} > jdbc:phoenix:thin: > url=https://<host>:<port>; > serialization=PROTOBUF; > authentication=BASIC; > avatica_user=<userName>; > avatica_password=<userPw> > useClientSideLB: [true/false] > lbStrategy: [RandomDistribution/Sequential/RoundRobin] > lbURLs: <comma separated URls e.g. URL1, URL2,URL3,...URLn> {code} > Client should connect to any of the URLs specified in lbURLs ( depending on > LB strategy selected). Please refer to [^Avatica Basic client side load > balancing.docx]for more details > -- This message was sent by Atlassian Jira (v8.20.10#820010)