Topologies for Web Synchronization
Applies To: SQL Server 2016
You can choose from a variety of Microsoft SQL Server Web synchronization replication topologies. Common ways to configure Web synchronization include:
Multiple Microsoft Internet Information Services (IIS) systems and SQL Server republishing
For information about configuring Web synchronization, see Configure Web Synchronization.
In the simplest topology, IIS, the SQL Server Publisher, and the SQL Server Distributor all reside on a single server. Subscribers synchronize by connecting to IIS on the Publisher. The Publisher can be located behind a firewall.
You can place IIS on one server and configure the SQL Server Publisher and Distributor on another server. The server running IIS can be isolated from the Internet by a firewall. Subscribers synchronize by connecting to IIS.
If you need to support very large numbers of Subscribers that synchronize at the same time, you can partition the work across multiple computers running IIS.
If further load balancing is required on the computer running SQL Server, you can create a republishing hierarchy on multiple computers. The top-level Publisher publishes data to Subscribers, which in turn republish the data, load balancing requests from the Subscribers.