locked
Failover Clustering ofthe distributor and subscribers in SQL Server 2012 Standard Edition RRS feed

  • Question

  • In our replication topology, we have a server that is a distributor and a subscriber to 3 publishers. This server is a single point of failure as input to a critical application. We are thinking of configuring a failover cluster with this server as one of the nodes. We are planning to upgrade to SQL Server 2012 standard edition.

    Question: Can we have automatic failover from one server to the other with redundant databases including the distribution database ? User databases can be mirrored but how about the distribution database ?

    Friday, October 25, 2013 1:28 PM

Answers

  • Ok, but Mirroring and AGs are not supported for the Distribution database. 

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Farid Kettani Friday, October 25, 2013 7:31 PM
    Friday, October 25, 2013 7:09 PM

All replies

  • You can't use Mirroring or AlwaysOn Availibilty Groups with a Distributor, but you can use AlwaysOn Failover Cluster Instances.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Friday, October 25, 2013 3:21 PM
  • David,

    I totally agree. But is it possible to use Failover Cluster instances with non-shared distribution database?. I mean, every node of the cluster has its own distribution database, but only one is active at a time. I know that we can have failover clusters with mirrored user databases in the standard edition. :

    http://technet.microsoft.com/en-us/library/ms191309.aspx

    Thanks for your reply

    Farid

    Friday, October 25, 2013 3:46 PM
  • With an AlwaysOn Failover Cluster Instance (FCI), you only have one instance.  That instance is installed on multiple nodes of the cluster, and is only running on one node at any time.  That instance has its own name and IP address.

    There is no mirroring and only a single copy of each database with and FCI.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Friday, October 25, 2013 4:09 PM
  • Agree again.

    How about putting each server on a distinct FCI, as specified in http://technet.microsoft.com/en-us/library/ms191309.aspx ?

    Farid

    Friday, October 25, 2013 5:13 PM
  • >How about putting each server on a distinct FCI

    I don't understand the question well enough to comment.  Can you clarify your scenario and what you are proposing?

    David


    David http://blogs.msdn.com/b/dbrowne/


    Friday, October 25, 2013 5:49 PM
  • The principal server and mirror server both reside on clusters, with the principal server running on the failover clustered instance of one cluster and the mirror server running on the failover clustered instance of a different cluster.
    Friday, October 25, 2013 6:21 PM
  • Ok, but Mirroring and AGs are not supported for the Distribution database. 

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Farid Kettani Friday, October 25, 2013 7:31 PM
    Friday, October 25, 2013 7:09 PM
  • Thanks. It answers my question.
    Friday, October 25, 2013 7:31 PM