Cheapest iSCSI SAN for Windows 2008/SQL Server clustering?
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.
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).
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
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.