对等复制中节点数量的限制 [英] limitation on number of nodes in peer to peer replication

问题描述

如果我们在SQL Server 2016环境中使用对等复制，那么可以进行对等拓扑的节点数量有限制吗？

在写操作中导致性能不佳的节点数是多少，因为每个节点都要将更新写入n-1个其他节点

请问？

解决方案

嗨Oula ，

 

>>如果我们在SQL Server 2016环境中使用对等复制，那么可以进行对等拓扑的节点数量是否有限制？ / p>

 

根据我的研究，我没有找到微软对对等复制中的节点上限有清楚的解释。对端复制的一些其他限制，例如，仅在SQL Server的企业版中支持对等到
对等复制。请参阅

https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql -server-2017＃general-consideration

 

>>因为每个节点都在运行，导致写操作性能不佳的节点数是多少将更新写入n-1个其他节点

 

每个节点都充当发布者和订阅者，这意味着它接收并向其他节点发送事务。对等复制的主要概念是每个节点都使用
更新数据，但负责更新自己的数据，因此这是拥有相同模式和数据的基本要求。

 

希望这可以帮到你。

最好的问候，

Dedmon Dai

if we are using a peer to peer replication in SQL Server 2016 environment is there any limitation in number of nodes that can make peer to peer topology ?

and what is the number of nodes that can lead to bad performance in write operation because each node is going to write the update to n-1 other node

any hep please?

解决方案

Hi Oula,

 

>>if we are using a peer to peer replication in SQL Server 2016 environment is there any limitation in number of nodes that can make peer to peer topology ?

 

Based on my research, I don't find that Microsoft has a clear explanation of the node ceiling in peer-to-peer replication. Some other restrictions on peer-to-peer replication, for example, peer to peer replication is supported in the Enterprise version of SQL server only. Please refer to https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql-server-2017#general-considerations

 

>>what is the number of nodes that can lead to bad performance in write operation because each node is going to write the update to n-1 other node

 

Each node acts as a publisher as well as a subscriber that means it receives and sends transactions to other nodes. The primary concept of peer to peer replication is that each node is updated with the data but responsible for updating its own data thus it is the essential requirement to have identical schema and data.

 

Hope this could help you .

Best regards,

Dedmon Dai

这篇关于对等复制中节点数量的限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！