Cari Blog Ini

16 Juli 2012

Example of Peer-to-Peer Transactional Replication To Scale Out Database Solution Geographically

Peer-to-peer transactional replication works best
where your DML operations are mutually exclusive to each site
and is designed to scale out your geographic workload
by automatically replicating data between these remote sites, as shown in Figure 32-10.

In this scenario, you have help desks based in Sydney, Florence, and Seattle
that are used to service your organization globally.
If each help desk site operates in a window of time mutually exclusive from the other two,
there is no DML conflict as help desk operators addand resolve customer problems.

(This scenario would also work, irrespective of the time window,
if each help desk site services only its regions customers
because all DML operations will also be mutually exclusive.)




Source: Microsoft SQL 2005 Administrator's Companion,
Page 1106