December 30, 2009 at 11:31 am
I had a vendor whose application is supposed to work with mirroring. so I built a development Mirror using HAOM (High Availability Operating Mode).
come to find out thier application did not work as expected using transparent client redirect.
So the question I had recieved was, is there any way that SQL can forward transaction request to which ever server is the Principal. I said No, as it sounds more like they would want a cluster with a common server name for the virtual server.
But I was curious if anybody else had actually done something like that?
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 2, 2010 at 3:57 pm
Hmmm... IMHO if you specify the failover partner in the connection string and your application can reconnect after a failure, this should work. If the principal is active, then it works without any hassle; if the mirror is the active, after the connection failure the app will try to connect to the mirror and succeed.
Or did I misunderstand your question?
-- Erik http://blog.rollback.hu
January 8, 2010 at 8:54 am
yes, you can take the app code out of mirroring by using virtual DNS entries. But, there is not a way to "automate" it.
we use a Global Site Selector from Cisco to point to both database servers.
the GSS knows which one is active by a manually telling it which one is active.
the apps point to the GSS device.
upon a failover, the DBA's have to make a quick edit of the GSS entry and the app will start to work.
Cisco does not have a way for SQL to control this. (yet)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply