我可以将FCI与复制结合起来吗？ [英] Can I combine FCI with Replication?

问题描述

我们已经复制了。发布者和订阅者（​​只读）。截至目前尚未设置高可用性。 

We have replication in place. A publisher and a subscriber(read-only). No High availability set up as of now. 

我们计划在MSSQL 2016标准版中安装故障转移群集实例。 

We are planning to have Failover cluster Instance with MSSQL 2016 standard edition. 

我们还需要一个只读副本。是否可以在FCI之上进行复制（对于只读副本）。请建议。

We also need a read-only copy. Will it be possible to have replication (for a read-only copy) on top of FCI. Please suggest.

任何指向某些文章的指针都会很棒！ 

Any pointers to some articles would be great too! 

提前致谢

推荐答案

Hi Mounika91，

Hi Mounika91,

 

如果您尝试在FCI和单独的实例之间配置复制，则可以，但如果您尝试在每个FCI节点上配置复制，则无法进行此操作。

It is okay if you try to configure replication between FCI and a separate instance, but if you try to configure replication on each FCI node, this is not possible.

 

复制不关心或与群集交互。 复制是从SQL实例到SQL实例，即inst的物理主机当前正在运行的ance
是不相关的。如果发生故障转移，则在实例脱机时会出现复制的瞬间中断，但是一旦SQL出现在另一台主机上，它将恢复。 / span>

Replication doesn't care about or interact with clustering.Replication is set up from SQL instance to SQL instance, the physical host that the instance happens to be running on at that moment isn't relevant.If a failover occurs, a momentary interruption in replication will be experienced as the instance goes offline, but will resume once SQL comes up on the other host.

 

最好的问候，

Dedmon Dai

Dedmon Dai

这篇关于我可以将FCI与复制结合起来吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！