Solved

Storage cluster?

Posted on 2011-02-16
3
697 Views
Last Modified: 2012-05-11
I'm needing to create shared storage for my SQL Server cluster.  We do not want a SAN due to it's cost and complexity.  Rather I want to create a storage cluster using a pair of servers with direct attached storage (RAID 10).  What is the best way to get this done?  Performance and disk IO matter alot, so it needs to be fast.

It would look like this:

Server #1 + 14TB [Primary node]
Server #2 + 14TB [Hot Standby node]

**In an emergency Server #2 seamlessly picks up the load
0
Comment
Question by:Phil5780
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Author Comment

by:Phil5780
ID: 34912086
Is Windows Storage Server 2008 able to provide clustering like this?
0
 
LVL 47

Accepted Solution

by:
dlethe earned 250 total points
ID: 34912977
I am going to assume active/passive ... because active-active, i.e, both systems reading and writing to the same volume at the same time is going to destroy your budget.

Some options are ...
1) Get an older PC and load X64 Solaris or Nexenta on it, and use the native zfs software-RAID. It is much superior to RAID1 in reliability, performance, and data integrity.  Then set up the O/S to present the shares as iSCSI target(s).

2) External FC used RAID subsystem. Lots of stuff on ebay, especially for fibre channel-based RAID. Stuff that went for $25K++ 5 years ago are in the $1000 range.
0
 
LVL 55

Assisted Solution

by:andyalder
andyalder earned 250 total points
ID: 34914906
>Is Windows Storage Server 2008 able to provide clustering like this?

It can but it would cost more than a shared SAS storage box. You'd be far better off with a Dell MD3000 or HP MSA2000sa.

For example from HP side -

Dual controller SAS attached storage box...
1 * AW593A dual controller P2000 £5,750.00
4 * SAS HBAs 4 * £125 = £500
12 * 600GB 15K disks 12 * £387.83 = £4656
Total £10900

Vs
Two servers for storage (without software)
2 * ML350 entry level servers £2100
24 * 600GB 15K disks 24 * £373 = £8952
(sundries omitted)
Total £11052

Near enough the same price but I haven't added enough disks. For the dual-server configuration you have to add twice as many disks as you have to add to the dual controller SAS (or iSCSI) connected SAN. Plus you have to install and maintain the OS on your storage servers whereas it's just firmware on the SAS attached storage boxes.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IMAP storage issue 6 74
Moving on from sbs 2008... 36 87
Should I swap to a solid state disk? 13 58
robocopy fails- error 53 - network path not found 5 31
A procedure for exporting installed hotfix details of remote computers using powershell
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question