Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 5 down vote favorite

Is it possible to create a two node cluster using two basic network servers that only have local disks?

One will act as an idle standby server. Without knowing too much about clustering I'm not sure if a separate shared disk array is required.

If so, is it possible to use a DAS setup, or does it have to be a SAN that supports clustering?

share|improve this question

migrated from stackoverflow.com Aug 22 '12 at 5:02

4 Answers

up vote 6 down vote

I am afraid that this is not possible. Clustering works on the basis of resource ownership and acquisition; so anything that is not accessible to all nodes in the cluster cannot be used.

If shared storage is not an option for you then have a look at using mirroring which does not require storage to be shared across multiple servers. You could even use a witness server to automatically fail over should the primary become unreachable for any reason:

DATABASE MIRRORING

http://msdn.microsoft.com/en-us/library/ms189852.aspx

SQL CLUSTERING CONSIDERATIONS

http://msdn.microsoft.com/en-us/library/ms189910.aspx

I hope this helps you.

share|improve this answer
Can this be done with virtualization? Or perhaps iSCSI and a clustered file system (I don't anything about this kind of setup on Windows though) – Jack Douglas♦ Aug 22 '12 at 9:56
Hi Jack, SQL Server only supports local disks for storing the tempdb on. iSCSI is supported but from my understanding of the above question this is not available to the OP. – Mr.Brownstone Aug 22 '12 at 10:54
Is that because he is not on 2012? – Jack Douglas♦ Aug 22 '12 at 11:41
Yes. Mirroring is the best option pre-2012. 2012 AlwaysOn Availability Groups would also move toward a shared nothing cluster. – swasheck Sep 5 '12 at 21:12
up vote 2 down vote

This is sort of possible using the SQL 2012 AlwaysOn feature, which allows you to create a cluster between two nodes that do not share storage. The setup uses database mirroring behind the scenes to replicate the data to the remote nodes storage but I don't think automatic failover is possible, would have to be kicked off by a user or process.

share|improve this answer
up vote 1 down vote

No, it is not possible to create a SQL cluster as you have described it.

share|improve this answer
It would be nice if you could explain your answer a bit more. For instance, what options does one have in creating the shared disk? – Max Vernon Sep 5 '12 at 17:49
That was not part of the original question. He asked a very straightforward question, I gave a straighforward answer. – datagod Sep 6 '12 at 13:10
1  
I'm sorry - I had no intention of offending you; if in fact I have. – Max Vernon Sep 6 '12 at 13:59
up vote 1 down vote

Not in 2008, but in SQL 2012 you don't need to have shared storage and it WILL perform automatic failover if configured, as well as seperating read and write load, offsite backups and automatic corruption detection and repair.

You only need to file structure (disk letters and folder locations to be identical on the servers) if your going to consider this... check out these links...

http://msdn.microsoft.com/en-us/library/jj215886.aspx

then use brent's great checklist (this also contains further links to important pre reqs that you MUST perform and test before installing AlwaysON :

http://i.brentozar.com/sql-server-2012-alwayson-availability-groups-setup-checklist.pdf

the only showstopper may be, this is only available in enterprise edition...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.