Re: Problems with jdbc loadbalance

[Todd Farmer]

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
http://www.oracle.com/mysql/