Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HA on Active / ACtive and DR on DB Mirroring Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2012 2:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
I have 2 SQL Servers in HA set up in Active / Active cluster where we have one DB - named XYZ. Versions : Windows Server 2008 R2 and sql server 2008 R2

We have a 3rd SQL Server in DR Setup where we have asynch DB Mirroring setup b/w the DR node and Active/Active Cluster.

What will happen when the cluster is failing over to another node and the Mirroring swaps roles and another node becomes Principal. Will Mirroring continue to work from another node [ new Principal ] to DR node ? Or will we see any problems ?
Post #1363854
Posted Tuesday, September 25, 2012 3:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 6,196, Visits: 13,354
Kishore-132325 (9/25/2012)
I have 2 SQL Servers in HA set up in Active / Active cluster where we have one DB - named XYZ. Versions : Windows Server 2008 R2 and sql server 2008 R2

We have a 3rd SQL Server in DR Setup where we have asynch DB Mirroring setup b/w the DR node and Active/Active Cluster.

you have a multi instance cluster is that correct?



Kishore-132325 (9/25/2012)
What will happen when the cluster is failing over to another node and the Mirroring swaps roles and another node becomes Principal. Will Mirroring continue to work from another node [ new Principal ] to DR node ? Or will we see any problems ?

What mode is your mirror session configured for?
Asynch, synch, auto failover???


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1363886
Posted Tuesday, September 25, 2012 3:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
Yes multi instance cluster...

DB Mirroring is in Asynch mode and Manual failover...
Post #1363889
Posted Tuesday, September 25, 2012 3:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 6,196, Visits: 13,354
Kishore-132325 (9/25/2012)
Yes multi instance cluster...

DB Mirroring is in Asynch mode and Manual failover...

If the cluster fails over and the failover time exceeds the mirror timeout (default is 10 seconds) the mirror will become disconnected.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1363894
Posted Tuesday, September 25, 2012 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
ok, gotcha..
but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?
Post #1363899
Posted Tuesday, September 25, 2012 4:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 6,196, Visits: 13,354
Kishore-132325 (9/25/2012)
ok, gotcha..
but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?

What new principal?
The mirror session is created against the clustered SQL Server instance not the cluster node it runs on.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1363926
Posted Tuesday, September 25, 2012 5:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
got it... thank you :)
Post #1363954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse