0

Per this article, a Publisher can only have one remote Distributor in doing SQL Server Transactional Replication.

Each Publisher can be assigned to only a single Distributor instance, but multiple publishers can share a Distributor.

If this is the case, I am wondering how to scale out the publication of a database to a large number of Subscribers. Supposing a Publisher had 200 Subscribers with a large number of transactions, what would be a workable distribution architecture that could handle that load?

Scenario is 'one source of truth' - up to 200 read-only slaves in different geographical areas that each get a slice of the central source, based on data pertinent to their local area (filtered rows).

All writes are made to the central master, which then need to propagate down to the local slave in as close to instant as possible. I've done a bit of research and transactional replication seems to be the best bet.

0

1 Answer 1

0

Could you maybe create a set of middle man subscribers whom also have a publisher schema of the same sets of data using their own distributor?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.