September 25, 2012 at 2:32 am
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 ?
September 25, 2012 at 3:40 am
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 R2We 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" 😉
September 25, 2012 at 3:49 am
Yes multi instance cluster...
DB Mirroring is in Asynch mode and Manual failover...
September 25, 2012 at 3:56 am
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" 😉
September 25, 2012 at 3:59 am
ok, gotcha..
but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?
September 25, 2012 at 4:37 am
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" 😉
September 25, 2012 at 5:25 am
got it... thank you 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply