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.