Re: Problems with jdbc loadbalance
Posted by: Todd Farmer
Date: September 12, 2013 08:28AM

Hello Egor,

You'll want to make sure you set the following properties as well:

loadBalanceBlacklistTimeout - set reasonably high to avoid reselection of down host. For example, if you want the problematic host to be retried once a minute, use 60000. This will help direct the majority of rebalance attempts to the server that's responding.

loadBalancePingTimeout - set this reasonably low - especially if you have loadBalanceValidateConnectionOnSwapServer=true - to limit the time Connector/J will wait for a response to a ping operation.

If those don't resolve the problem, it would be good to post the connection properties you are using (no user/password/hostnames), and see if you can get a stack trace from a debugging environment when the hang is observed.

Hope that helps!

Todd Farmer
MySQL @ Oracle

Options: ReplyQuote

Written By
September 12, 2013 02:45AM
Re: Problems with jdbc loadbalance
September 12, 2013 08:28AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.