Need some suggestions about how to limit replication of MDCs
Posted on 2004-04-22
Many of our users work locally and have scheduled replication for certain databases, primarily their mail file and the MDCs set up. Although the two MDCs are only around six megs each, when we do (not infrequent) updates to the NAB, that of course also affects the MDCs, and when thousands of users hit a server for the scheduled replication, it is causing a huge hit on the WAN. The proposed solution was to restrict the replication alphabetically so that each user replicated the MDCs only once per week, splitting the replication to approximately 20% each day. One of the programmers tried this by using the replication formula:
select @Modulo(@Length(@Name([Abbreviate];@UserName));5))+1 = @weekday(@today)
1 = monday, 2 = tuesday ......
That didn't work. If it's tried on a non-allowed day, it completely wipes out the local MDC.
Any suggestions about how the MDCs can be replicated selectively would be much appreciated.