sql-server - SQL Server 的对等复制和合并复制有什么区别？

Question

使用 SQL Server 的对等复制和合并复制有什么区别？

Answer 1

1. 点对点交易复制通常用于支持分发读取的应用程序跨多个服务器的操作节点。

Although peer-to-peer replication enables scaling out of read operations, write performance for the topology is like that for a single node, this is because ultimately all inserts, updates, and deletes are propagated to all nodes. If one of the nodes in the system fails, an application layer can redirect the writes for that node to another node, this is not a requirement but does maintain availability if a node fails.

参见:Peer-To-Peer Replicaiton

合并复制是双向的即读取和写入操作是传播到所有节点或从所有节点传播。合并复制通常需要实现conflictresolution .

参见:How Merge Replication Works