Database Reference
In-Depth Information
Figure 31-9. Transactional Replication with Push subscriptions
Peer-to-peer replication, shown in Figure 31-10 , allows you to build a distributed and scalable solution with
multiple updateable databases residing on different servers called nodes . It is an Enterprise Edition feature that is
based on transaction replication, and therefore it has a very low latency to distribute the changes between nodes.
One scenario when it is useful is with a system with multiple datacenters. You can host individual SQL Servers in
every datacenter and redirect clients to the nearest one. Peer-to-peer replication synchronizes data across all nodes
and handles the situation when a node temporarily loses connectivity with other nodes.
 
Search WWH ::




Custom Search