Cheapest iSCSI SAN for Windows 2008/SQL Server clustering?

Question

Are there any production-quality iSCSI SANs suitable for use with Windows Server 2008/SQL Server for failover clustering?

So far, I've only seen Dell's MD3000i, and HP's MSA 2000 (2012i), which both are around $6K with a minimal disk configuration. Buffalo (yea, I know), has a $1000 device with iSCSI support, but they say it will not work for 2008 failover clustering.

I'm interested in seeing something suitable for failover in a production environment, but with very low IO requirements. (Clustering, say, a 30GB DB.)

As for using software: On Windows, StarWind seems to have a great solution. But it's actually more money than buying a hardware SAN. (As I understand, only the enterprise edition supports having replicas, and that's $3000 a license.)

I was thinking I could use Linux, something like DRBD + an iSCSI target would be fine. However, I haven't seen any free or low-cost iSCSI software that supports SCSI-3 persistent reservations, which Windows 2008 needs for failover clustering.

I know $6K isn't much at all, just curious to see if there are practical cheaper solutions out there. And finally, yes, the software is expensive, but many small business get MS BizSpark, so the Windows 2008 Enterprise / SQL 2008 licenses are completely free.

Solution 1

Consider whether you really need hot failover. If you're worrying about price at the level of an entry level SAN then consider whether you really have a business case for that recovery model. How expensive is your downtime for an outage?

If the cost of an outage justifies the cost of a decent SAN, buy it and don't penny pinch. Otherwise, consider other failover models. If your downtime is not so valuable, you can probably tolerate a hot standby model where the database is replicated to another server with local disk. This takes longer to recover but does not need shared disk storage. If this works for you then you don't need a SAN and the local disk on the servers will probably be much cheaper.

Another option would be the secondhand market. You can get a re-certified second hand Clariion CX200 or CX300 (which would probably do what you're after) for just a few thousand dollars. Re-certified hardware qualifies for vendor support and can be purchased through various outfits such as www.berkcom.com or www.bltserv.com.

(Disclaimer: I have no affiliation with either vendor but am a satisfied customer of BLT Services. Berkcom was recommended to me when I needed something that BLT didn't have).

Solution 2

It might not be the ideal high availability solution, but many people coming to this tread want to know about the solutions for running a Windows Server 2008 cluster with limited funds.

Here are some options.

As indicated for an iSCSI solution you will need iSCSI-3 persistent reservations for failover clustering to work in Windows Server 2008. See http://www.servercare.nl/Lists/Posts/Post.aspx?ID=71 for a good overview.

Low cost software solutions that are reported to work include [1]:

• Kernsafe's iStorage Server ( http://www.kernsafe.com/Product.aspx?id=5 ) (USD 99.95 Personal Edition)
• YoungZSoft iSCSI Cake ( http://www.iscsicake.com/ ) (USD 69, Personal Edition)
• Open-E iSCSI-R3 ( http://www.open-e.com/products/iscsi-r3/ ) (USD 597, 4TB limit)
• StarWind Software StarWind Free ( http://www.starwindsoftware.com/free , USD 0, 2TB limit)

Low cost software solutions that will not work (at the present time, but might soon)

• Openfiler ( http://www.openfiler.com/ ) [2]
• FreeNAS ( http://www.freenas.org/ ) [3]
• Open Solaris ( http://opensolaris.org/os/ ) [4]

Most low cost hardware solutions such as Thecus, Qnap, NetGear etc. do not currently work.

Drobo does not currently work [5]

Synology NAS running DSM 3.0 claims to work [6]

[1] Support might be forthcoming through a commercial plug-in: http://forums.openfiler.com/viewtopic.php?id=2102

[2] Support already present in nightly builds ( http://sourceforge.net/project/showfiles.php?group_id=151951&package_id=229704 ) as reported in http://www.servercare.nl/Lists/Posts/Post.aspx?ID=61

[3] Support might be forthcoming ( http://opensolaris.org/jive/thread.jspa?messageID=312634 )

[4] Hyper-V and Drobo Pro

[5] http://www.synology.com/us/products/features/iSCSI.php

Solution 3

I can say only one thing: Starwind. Their free version offers all you need, limiting only in storage size - 2Tb. I like testing of my virtual machines so much, that our company bought it for implementing shared storage. Working with already for a few years, and can say that it`s greatest thing. I used to work with Datacore and openfiler, but they are to complicated and bugful respectively.

Solution 4

If you absolutely have to insist on iSCSI, then yes, there are some in-the-middle solutions out there, although they do cost more than $1k. Don't let the off-brand name fool you, we've been using a variant in eSATA form for over 2 years with no failures, no hiccups, and no downtime (that wasn't planned). Performance has been good, 250Mb/sec sustained with 300Mb/sec peak, although our setup allows for some minimal (5 minute) downtime for failover.

Yes, Linux would give you a cheap-o iSCSI solution as well, although I'm not sure about your other requirements.

Solution 5

Openfiler will soon be testing this feature. You can view a thread on it here:

https://forums.openfiler.com/viewtopic.php?id=2102&p=1

Make sure to check out the 2nd page of the thread for a possible working solution.

View more solutions

Comments

[Randall Salas]

The question I have with your request is how highly available the storage solution needs to be for you to consider it "production". Coupling two clustered systems with a non-clustered, potentially non-redundant storage system might work, but many would not consider it "production".

[kmarsh]

Consider the cost of extended support very carefully when pricing off-brand solutions. Dell and HP usually have very reasonable next business day replacement support.

[Gareth Williams]

Yea, it's the SCSI-3 persistent reservations that clustering needs that seem to rule out a lot of the software or cheaper ones.

[Gareth Williams]

Completely valid point. It's actually a few databases and the service broker, so mirroring doesn't work. We are using replication / tx log shipping to have a manual failover now. Just trying to figure out what the minimum is to get a hot failover.

[Avery Payne]

Contact Promise directly. They will pass your questions along to their engineers, who understand the product intimately. They should be able to answer your SCSI-3 persistent reservation question in a short time. We did this with our iSCSI eval unit re: multipathing support, which in our unit wasn't supported; they answered us in less than 72 hours.

[Peter Stuer]

The Thecus pro series does not support SCSI-3 persistent reservations.

[Gareth Williams]

What software supports SCSI-3 persistent reservations? Cause a real iSCSI solution that supports that, backed by drbd would be a very nice "cheap" solution with decent failure characteristics.

[Simon Tower]

Also, LIO-Target v3.1.x is what Netgear and QNAP have been shipping in their NAS products..

[Admin]

StarWind Free can't be used in cluster anymore, just wast time, I contacted to starwind, but they told us to buy a high version for many times.