Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / July 2006

Tip: Looking for answers? Try searching our database.

Load Balanced Web Synchronization Against a Republisher Topology &

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BATMAN - 27 Jul 2006 18:06 GMT
We are using Web Synchronization against a Republisher topology...  Meaning
we are using load balanced IIS servers against republishers.  Right now Each
IIS server has a dedicated republisher pointing to a central server, not
across a WAN though.  Our goal was mainly to create a scalable environment
that will scale as our subscriber base grows.
The topology that I speak of is described in the below BOL article
(“Multiple IIS Systems and SQL Server Republishing” section at the bottom of
the article…).  Below is the link to that article:

http://msdn2.microsoft.com/en-us/library/ms151811.aspx

With that said…  We use RMO to setup the pull subscription on the client for
Web Synchronization.  We setup the client inline with the subscription
properties  necessary to use Web Synchronization.  Below are the steps
outlined in BOL:

http://msdn2.microsoft.com/en-us/library/ms345207.aspx

------------------------------------------------------------------------------------------
SQL Server 2005 Books Online  
How to: Configure a Subscription to Use Web Synchronization (RMO Programming)
------------------------------------------------------------------------------------------
Set the following subscription properties:
1)  The ServerConnection to the Subscriber created in step 1 for
ConnectionContext.
2)  Name of the subscription database for DatabaseName.
3)  Name of the Publisher for PublisherName.
4)  Name of the publication database for PublicationDBName.
5)  Name of the publication for PublicationName.
6)  Value of true for UseWebSynchronization.
7)  Location of the Web server that hosts Web synchronization for InternetUrl.
8)  Login and password for the Microsoft Windows account under which the
Merge Agent runs
9)  Value of 0 for InternetSecurityMode as well as values for InternetLogin
and InternetPassword when using HTTP Basic Authentication to access the Web
server using SQL Authentication credentials.
------------------------------------------------------------------------------------------

The problem is step “3)  Name of the Publisher for PublisherName. “ and how
it relates to load balancing the web servers.

So with all that said…  The challenge is how do we get around having to pass
the PublisherName which is the server/instance name when creating and syncing
the subscriptions in a load balanced Web Synchronization/Republisher topology
(a 1:1 Web to Republisher scenario…)?  

Thanks!
BATMAN - 28 Jul 2006 06:28 GMT
OK...  A more simple way to look at it...  Does SQL Server bind subscriptions
to publications?  After thinking about the whole repbulishing logic, the only
way a subscriber could get data from another publisher/republisher is if the
publication metadata, in the distribution db's, we'ere identical...  And
since republishers are independent publications created off of the source
publication, that is not possible...  So overall, to anser my own question, a
subsription cannot use the topology that is diagramed out in Microsofts
documentation, or at least the documentation is not detail enough to explain
how you would implement a republisher topology against a load balanced web
sychronization hiearchy.

With that said...  The only way I can see this solution working is to code
our own logic that does round robin load balancing and eveninly distribute
subsribers across web/sql pairs...

Anyone have any thoughts?

Thanks!

> We are using Web Synchronization against a Republisher topology...  Meaning
> we are using load balanced IIS servers against republishers.  Right now Each
[quoted text clipped - 43 lines]
>  
> Thanks!
Hilary Cotter - 29 Jul 2006 01:49 GMT
Subscribers are bound to their publishers. While merge replication does
support alternate sync publishers these require a manual failover to the
alternate and furthermore the subscriber can only attach to the alternate
for a limited time before having to reconnect to the main publisher.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> OK...  A more simple way to look at it...  Does SQL Server bind
> subscriptions
[quoted text clipped - 80 lines]
>>
>> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.