Question

1
Replies
44
Views
DeepakK4401 Member since 2013 6 posts
Healthfirst
Posted: 3 years ago
Last activity: 3 years 5 months ago
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
Share this page LinkedIn