SQL Server 2005 故障转移群集使用一台服务器？
我正在开发一个托管在 SQL Server 2005 故障转移群集上的应用程序。 该应用程序（使用 C#、.Net 2.0 开发）利用了许多集群资源（打印机、文件共享等）。 我想建立一个复制集群的测试环境。 然而，当前的测试环境只有一台 SQL 服务器，并且不可能获得第二台服务器来创建完整的集群。 有什么方法可以仅使用单个服务器来模拟集群环境吗？
任何建议将不胜感激。
非常感谢，MagicAndi。
I am developing an application that is hosted on a SQL Server 2005 failover cluster. The application (developed using C#, .Net 2.0) makes use of a number of the clustered resources (printers, file shares, etc). I would like to set up a testing environment that replicates the cluster. However, the current test environment has only one SQL server, and there is no hope of ever getting a second server to create a full cluster. Is there some way I can mock the cluster environment using only a single server?
Any advice would be much appreciated.
Many thanks, MagicAndi.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
使用虚拟机。 为此，我使用了 MS Virtual Server 和 R2，它支持创建虚拟集群。 当我必须针对集群进行测试并确保我的代码能够优雅地进行故障转移时，我已经这样做了很多次。
整个过程有点复杂，因为您需要创建一个虚拟专用网络，并让两个虚拟主机共享集群的虚拟 SCSI 驱动器，但幸运的是，有很好的分步指南。 这是一个很好的： http://www.microsoft.com/ technet/prodtechnol/virtualserver/deploy/cvs2005.mspx
集群启动并运行后，继续在其上安装集群 SQL 实例，该过程与在真实金属集群上执行的过程完全相同。
Use virtual machines. I had used MS Virtual Server and R2 for this, it has support for creating a virtual cluster. I've been doing this a lot of times when I had to test against clusters and make sure my code survives fail overs gracefully.
The whole process is a bit convoluted, as you will need to create a virtual private network and have the two virtual hosts share a virtual SCSI drive for the cluster, but fortunately there are good step by step guides out there. Here is a good one: http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx
Once you have your cluster up and running, go ahead and install a clustered SQL instance on it, the process is exactly as you would do it on a real metal cluster.
碰巧 SQL Server Central 今天发布了一篇关于此的文章：Setting up a SQL cluster under MS VS2005 R2 第 1 部分，作者：Perry Whittle
It just so happens that SQL Server Central posted an article on this today: Setting up a SQL cluster under MS VS2005 R2 Part1, By Perry Whittle
我认为你可以通过操作系统虚拟化来实现它。
I would think that you would be able to achieve it through OS virtualization.
唯一可能的选择是在一台服务器上设置虚拟机。 不过，老实说，我不知道 MS cluting 是否支持使用虚拟机作为集群节点。
About the only potential option would be to set up virtual machines on the one server. Honestly, however, I don't know if MS clutering supports using virtual machines as cluster nodes.
我还没有尝试过，但你可以尝试在服务器上安装另一个 sql server 实例。
I haven't tried it, but you could try installing another instance of sql server on the server.
不，MS集群确实支持使用虚拟机作为集群节点......如果物理机有良好的资源，那么使用虚拟机来测试集群环境是一个不错的选择。
No, MS clustering do supports using virtual machines as cluster nodes....and its a good option to use virtual machines for to test your cluster environment if the physical machine has a good resources.