All,
We're considering a SQL mirror to provide high-availablilty for the MS SQL database portion of our new Autosys installation (11.3.6). We've been previously running with dual event servers, but have found it cumbersome when one of the event servers becomes out of sync. We must take a schedule outage to re-sync the DBs and then restart. We're hoping avoid this by utilizing synchronous mirror solution provided by the DB tools.
I'm curious of a few different topics / questions:
- Is anyone using such a setup today?
- How did you address forcing Autosys to the partner in event of failover
Our DBAs are telling us to configure the application connection strings to provide the failover partner address, but we keep informing them this configuration does not appear possible within the application settings given the internally built ODBC connection strings. But, perhaps we're misunderstanding a key portion of the connection.
Thanks for reading / replying.
/josh