SQL Server Performance

SQL clustering + replication

Discussion in 'ALL SQL SERVER QUESTIONS' started by tboonleong, Aug 28, 2012.

  1. tboonleong Member

    I need to setup the transaction replication on the Active-Pasive clustering environment .
    How I am going to setup the distributor and publisher at this clustering environment in order to allow the failover from active machine to pasive machine.
    Do I also need to setup both distributor & publisher to both Active machine and Pasive machine as well?
    Or I only need to setup at Active machine only??
    Hope to get advice and tips.
    Thanks advance.
  2. ghemant Moderator

    In Cluster environment, the SQL Server cluster would be a virtual; thus it would not be on any physical node per say. For example, There is a SQL Cluster named SQLCLU which has 2 node, Node1 and Node2, at any given time SQLCLU will be owned by any of this node. So, when you configure Replication, it would be installed on SQLCLU and not on Node1 or Node2; in case of failover your replication will remain intact.
    hth

Share This Page