SQL Server Publisher Availability Group and Distributor

sysadmined 21 Reputation points
2021-01-27T09:57:07.653+00:00

Hi,

we have need for Failover Cluster with Alwayson Availability Group on 2 SQL Server 2016 Std SP2 CU 15 node host.

<node1> + <node2> = <node-cluster1>

Same databases are subscribed upon third single node <single-node-host>

Simply, it's necessary that Subscription is PUSH because <single-node-host> can send database updates to <node-cluster1> via AG Listener

<single-node-host>(database1 replica) ------ PULL -----> <node-cluster1>(database1 subscriber) (database1 in AG)

Another question is: the AG Cluster, for other databases, become Publisher, but based on microsoft doc the Distributor must be installed on separate istance.

We'd like to avoid installation of third node with another sql server license, is it possible install on <node1> and <node2> another SQL istances <node1>\Distrib and <node2>\Distrib where Distributor role is in AG?

<node1> + <node2> (Publisher AG) ------> <node1>\Distrib + <node2>\Distrib (Distributor AG)

is It possible? or we should install <node3> host with Distributor role?

Thank a lot.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,879 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-01-28T07:25:54.37+00:00

    Hi sysadmined-1931,

    is it possible install on <node1> and <node2> another SQL istances <node1>\Distrib and <node2>\Distrib where Distributor role is in AG?

    I’m afraid you can’t. For Basic Availability Groups in Standard Edition, you only can have two replicas (primary and secondary).

    we should install <node3> host with Distributor role?

    You can try to configure the remote distribution. Please refer to this article which might help.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments