SQL Server Publisher Availability Group and Distributor

Question

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.

Answer 1

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.