Home / server / Questions / 1028
Accepted
RobertTheGrey
Asked: 2009-05-01 07:23:59 +0800 CST

Cheap clustering for SQL server

  • 772

Does anyone know of a way to simulate a clustered SQL server solution? We obviously don't want to spend a lot of money prototyping the idea, but we have quite a few PCs available. I was just wondering if there was any way I could fool SQL server into thinking it's being installed on to clustered hardware by either using physical machines or even virtual machines?

I don't hope to do any performance testing of course, it's more to do with testing fail over scenarios and replication etc.

Any ideas?

sql-server cluster failover

3 Answers

  1. Best Answer

    The easiest way to do this is to build a virtual cluster in VMware. It's not technically supported unless you're on approved hardware/software, but for your needs, that's fine.

    The tricky part is the shared storage configuration, and this article explains how to do it:

    https://web.archive.org/web/1/http://techrepublic%2ecom%2ecom/5208-6230-0.html?forumID=102&threadID=220875&start=0

    • 8

  2. I was going to mention this exact approach that Brent outlined as it's a cheap way (from a hardware perspective) to play around with what's typically referred to as a 'pocket cluster'.

    Obviously though... this doesn't end up being that cheap if you're planning on using it in production, as you'll need at least 2 licenses of Windows Server Enterprise, and 1 license of SQL Server Enterprise (per each proc). But if it's just for testing then MSDN/TechNet licenses can be used and it's then just a question of hardware, virtualization, and configuration.

    • 1

  3. Physically you can likely do it using the physical workstations and an iSCSI solution for shared storage, since you're doing it as a test. The simpler approach is VMware, as Brent suggested. And just to make it clear, from a Microsoft perspective a fail-over cluster in VMware is not supported, even in an approved hardware/software solution.

    From Server Virtualization Validation Program FAQ:

    Does the SVVP cover all Windows Server roles? All Windows Server roles are supported with SVVP-validated solutions, except Hyper-V and Clustering Services. It does not make sense to run a hypervisor (Hyper-V) on another virtualization solution/hypervisor, and Clustering requires all of the hardware components to be tested by the hardware OEM (e.g. server, storage, HBA controller, operating system).

    • 1