Question

1
Replies
49
Views
Close popover
Deepak Kalluri (DeepakK4401)
Healthfirst

Healthfirst
US
DeepakK4401 Member since 2013 6 posts
Healthfirst
Posted: April 21, 2017
Last activity: April 21, 2017
Closed

Placing DR data base setting in config file

How we can put a fail over connection string pointing to DR site when disaster happens. This will save us steps to make changes to hundreds of JVMs when we have to bring JVMs up on DR site. We need to have minimum possible time to recover and target 0 manual steps when we fail over.

<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://XXXXX\XXXX:XXXX;integratedSecurity=true;SendStringParametersAsUnicode=false;SelectMethod=cursor;DatabaseName=XXXX1D"
maxActive="100"
maxIdle="30"
maxWait="10000"
/>

So far the only solution we have is to change the servername with the DNS alias and when failover happens change the alias to the fail over SQL server.

System Administration
Moderation Team has archived post