Re: MySQL connection does not work when slave db is down using sql connector 5.1.39
Posted by: pavan challa
Date: June 01, 2016 03:00AM

Hi Filipe,

Thanks for the reply.... finally I was able to get it to work from the below URL properties...

I have set the retriesAllDown to 1.

jdbc:mysql://${DATABASE_HOST_ADDRESSES}/${DATABASE_SCHEMA_NAME}?
connectTimeout=500&
socketTimeout=500&
retriesAllDown=1&
allowMasterDownConnections=true&
allowSlaveDownConnections=false&
loadBalanceBlacklistTimeout=50000&
readFromMasterWhenNoSlaves=true&

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL connection does not work when slave db is down using sql connector 5.1.39
June 01, 2016 03:00AM


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.