如何在没有见证的情况下通过SQL镜像在SP2010上设置DR? [英] How to setup DR on SP2010 with SQL mirroring without witness?

问题描述

我们有一个SP2010企业服务器场.当前，它使用SQL2008R2进行群集，并且我们计划在服务器场中添加DR.由于某些技术限制，我们无法将第二台sql服务器移至DR数据中心并保持群集.

We have a SP2010 enterprise farm. Currently it is using SQL2008R2 with clustering and we planned to add DR on the farm. Due to some technical restriction, we cannot move the 2nd sql server to DR datacenter and keep the clustering.

因此，我们决定删除群集并改用镜像.我们没有其他见证服务器的预算.

So we decide to remove clustering and use mirroring instead. We do not have budget for additional witness server.

我浏览了这篇微软文章:
使用SQL Server数据库镜像配置可用性(SharePoint Server 2010).

I have went though this Microsoft article :
Configure availability by using SQL Server database mirroring (SharePoint Server 2010).

SharePoint 2010似乎设计得很好，可以支持镜像.但是我找不到有关在没有见证的情况下进行镜像的参考.

It seems SharePoint 2010 is well designed to support mirroring. But I fail to find any reference about mirroring without witness.

请告诉我程序是什么?在没有见证的情况下，第二个sql需要从镜像同步"更改为第二个sql".手动激活.此时，SharePoint将知道主SQL已关闭并切换到辅助SQL(之前 准备好了吗?

Could you please advise what would be the procedure? Without witness, the 2nd sql need to change from "Mirror, Synchronized" to active manually. At this moment, will SharePoint aware the primary SQL is down and switch to secondary (before it is ready)?

推荐答案

镜像中的见证服务器是可选服务器，用于监视Principle和Mirror服务器之间的通信.

A Witness Server in mirroring is an optional server who watches the communication between Principle and Mirror server. 

In high-performance mode, the witness can adversely affect availability. If a witness is configured for a database mirroring session, the principal server must be connected at least to one of the other server instances, the mirror server or the witness, or both of them. Otherwise, the database becomes unavailable and forcing service (with possible data loss) is impossible. Therefore, for high-performance mode, we strongly recommend that you always keep the witness set to OFF. 

来源: https://docs .microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-witness

默认情况下，除非它关闭，否则所有内容都将指向您的Principle(或主)服务器.一旦您的主服务器(或主服务器)关闭，镜像服务器(或辅助服务器)将自动启动.这是最大的优势或镜像之一 它的故障是自动的.您可以先尝试在非生产环境中为任何示例数据库设置镜像.看 此处 有关如何在SQL Server中设置镜像的完整详细信息.

By default everything would be pointing to your Principle (or Primary) server unless it goes off. Once your Principle (or Primary) server goes down, the Mirror (or Secondary) server will be UP automatically. This is one of the big advantage or mirroring that its failure is automatic. You can try setting up mirroring for any sample database on non-production environment first. See here the complete details on how to setup mirroring in SQL Server.

要注意的一件事非常重要，也是问题的一部分，SharePoint将自动检查主SQL是否可用.见证服务器仅用于确保主服务器和辅助服务器之间的事务.一旦没有回应 从Primary SQL Server中，其上的数据库将自动将其模式设置为被动模式，而从属SQL Server上的数据库将处于活动状态.如果辅助服务器关闭，则主服务器将启动，也会发生相同的情况.整个过程 切换将非常快，用户甚至不会注意到已经进行了数据库切换.

One thing is very important to note and also part of your question, SharePoint will automatically check if the Primary SQL is available or not. The witness server is to only ensure transactions between Primary and Secondary server. Once there is no response from Primary SQL Server, the database on it will automatically set its mode passive and the database on Secondary SQL server will be in Active state. The same case will happen if the Secondary server goes down then the Primary will be up. In whole this process the switching will be very fast and users will not even notice that there was database switching.

SharePoint使您可以通过UI为Web应用程序设置故障转移SQL服务器，但不能为所有服务应用程序设置故障转移SQL服务器.对于包含数据库的服务应用程序，可以使用PowerShell设置其故障转移数据库.我强烈 建议首先在非生产环境中进行整个过程，因为这可能是一些意料之外的挑战.此外，尽管仅设置了镜像，但最佳做法是在其他地方保留数据库备份，以防万一 松开两个SQL服务器.

SharePoint provides the possibility to set a fail-over SQL server for web applications from UI but not for all service applications. For the service applications that contains a database, you can use PowerShell to set its fail-over databases. I strongly recommend to do this whole process in Non-Production environment first as their could be some unexpected challenges. Furthermore, despite setting up the mirroring only, its best practice that you keep backup of your databases on some other places in case you loose both of the SQL servers.

希望有帮助.

这篇关于如何在没有见证的情况下通过SQL镜像在SP2010上设置DR?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！