MySQL connection does not work when slave db is down using sql connector 5.1.39
Posted by: pavan challa
Date: May 26, 2016 06:08AM

We are using Java with a MySQL database. My SQL connector - 5.1.39.

URL :

jdbc:mysql://host1:port1,host1:port2/schema?allowSlaveDownConnections=true&loadBalanceBlacklistTimeout=50000&readFromMasterWhenNoSlaves=true

In the above URL, host1:port1 is the master and host1:port2 is the slave db .

Now, from the SQL connector - 5.1.38 , the parameter - allowSlaveDownConnections=true, should allow the connections even when the slave is down.

But practically, when the slave is down, the connection is not going through at all and getting a "connection timed out" error.

Please assist me in solving this issue. The goal is to get the app working even when the slave is down.

Options: ReplyQuote


Subject
Written By
Posted
MySQL connection does not work when slave db is down using sql connector 5.1.39
May 26, 2016 06:08AM


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.