Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: Problems with jdbc loadbalance


Advanced Search

Problems with jdbc loadbalance
Posted by: Egor Korobitsin ()
Date: September 12, 2013 02:45AM

Hi to all. I encountered on the problem, solution for which I can't find a long. I have application, which works on Tomcat, uses Apache DBCP and JDBC connector 5.1.25, Spring Framework and hibernate. I have 2 MySQL Servers, where replication is set. In JDBC's connection string I insert "loadbalance" and two out MySQL serveres as hosts. When I turn off first server (just shut down for example), my application hangs, and it seems that is tries to connect to offline MySQL server. And it lasts a long time.

I tried to configure connectTimeout and socketTimeout in JDBC's connection string, but it didn't help :(
Could anybody tell me where is a problem?

Thanks!



Edited 1 time(s). Last edit at 09/12/2013 02:47AM by Egor Korobitsin.

Options: ReplyQuote


Subject Written By Posted
Problems with jdbc loadbalance Egor Korobitsin 09/12/2013 02:45AM
Re: Problems with jdbc loadbalance Todd Farmer 09/12/2013 08:28AM
Re: Problems with jdbc loadbalance Egor Korobitsin 09/13/2013 06:06AM


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.