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

Mirroring with replication question Expand / Collapse
Author
Message
Posted Tuesday, April 30, 2013 6:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:07 AM
Points: 198, Visits: 667
Before I watched CBT Nuggets dicussing replication & mirroring. In it he described the following scenario (pictured below as I drew a diagram to help me understand his tongue twister.

http://www.pasteall.org/pic/show.php?id=50377

Paraphrasing, he said: "If the principal is mirrored then in the case of a failover it will still continue as expected; going from the mirrored server (new principal) to the subscribers. However, if it is a subscriber that is mirrored & that becomes avaiable then that subscriber will no longer be reached."

This makes sense because it is sending to servers rather than cluster names. However, my question is (or rather seeking confirmation) this outcome detailed is only true when the replication uses the PUSH model. If the replication was done in a PULL model then opposite would occur (subscriber could no longer find the failed over publisher but a failed over subscriber would still locate the publisher just fine). Am I right in this assumption?

Dird



Dird // Junior DBA
11g OCA
10.5 newbie
Post #1447991
Posted Wednesday, May 1, 2013 12:20 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:05 AM
Points: 907, Visits: 1,903
Edit - removed answer after rereading the question.
Post #1448558
Posted Tuesday, May 14, 2013 10:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 8, 2014 2:29 PM
Points: 2,321, Visits: 1,370
With a remote distributor the subscription can be configured as either push or pull. For high availability of replication you wouldn't want the publisher acting as its own distributor.

Whether you have a push or pull subscription the distribution agent will not recognize the failed over subscription mirror. You would have to setup replication for the new subscriber but you could use the initialize from lsn option rather than creating a new snapshot or restoring from backup.
Post #1452707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse