In database Mirroring can I have a virtual IP...

Question

In database Mirroring can I have a virtual IP...

forsqlserver

SSCoach

Points: 18902
More actions
September 13, 2010 at 1:50 am

#142689

In database Mirroring can I have a virtual IP...
Please tell fast..
Actually we were trying to install the sql server cluster but thats not possible bcoz it is in production of Domino Server.My confusion is "If one database goes down in database mirroring then other will come up but because there is no Virtual IP type of thing in this then how my application will connect to another without manual interruption of IP change..."
Thanks

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

cluster configuration is for server and mirroring is database specific. So failover will be only for a perticular database if you configure mirroring.

have a look of this article

http://www.mssqltips.com/tip.asp?tip=1564

----------
Ashish

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Thanx Ashish

I have also the single database but I want automatic connectivity of application to database if primary server fails..Guide me for this...

Thanks

crazy4sql SSCoach Points: 19590 More actions · Answer 3

i dont have much idea on coding so just tried to search for this issue and found this article

http://www.go4answers.com/Example/database-mirroring-asp-application-13913.aspx

hope it will answer your question.

----------
Ashish

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

forsqlserver (9/13/2010)
I have also the single database but I want automatic connectivity of application to database if primary server fails..Guide me for this...

http://www.google.com/search?q=%22transparent+client+redirect%22+mirroring

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 5

I have configured the witness server also in Mirror Server. But can you please tell how the application will connect to another database...

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Did you read the articles that search returns? Have you read up on client redirection in books online? (hint, a witness is not involved in transparent client redirection)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 7

Dear Gila,

Thanks,Some sites are blocked and not opening like google books, etc. and internet is slow today also.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

And Books online? Should be installed locally if you have any portion of SQL installed.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 9

you need the witness for automatic failover.

Setting up the witness on the same instance as the mirror sets up a single point of failure. You must have a quorum of the Witness + the instance that is currently hosting the mirror in order for automatic failover.

Do what Gail said and read up on Transparent Client Redirect there is a property in your code (it is dependent upon the driver and code type, but multiple platforms support it, but you must be on the correct version). Bottom line this will require research on your part to determine if your application can support it.

It is possible to set up DNS Aliasing using the same name, but this is not something that I have done, i've only read about the scenerio in a white paper about the combination of HA solutions, and it was referencing 2 clusters. The link to the white paper is below.

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 10

You should set the FailoverPartner = MirrorServerName in the conection string for the automatic failover to happen.

Data Source=PrincipalServer;Failover Partner=MirrorServer;Initial Catalog=MyDb;Integrated Security=SSPI

Thank You,

Best regards

SQLBuddy

forsqlserver SSCoach Points: 18902 More actions · Answer 11

Can I do one thing that I will install the default instance on both the machine and one extra instance on mirror server ,the I will create the ODBC System DSN for primary server ,but how will it connect to other sql server.My apps will connect through odbc but it wants automatic failover so in ODBC connectivity how it is possible??

Thanks

forsqlserver SSCoach Points: 18902 More actions · Answer 12

Thanks to all,Yet something below:

I have found that there is a "mirror Server" option in System DSN Sql Native Client configuration but one confusion is here that :

Should I have to create the same ODBC configuration with Mirror server database on Mirror Server without giving "mirror Server" name in this case??

Thanks

joseluisramirez21 SSC Rookie Points: 41 More actions · Answer 13

in your connection string in your application, use this Data Source="PrimaryServer";Failover Partner="MirrorServer";Initial Catalog="Database";Integrated Security=True