Solved

Clusters run on different hardware?

Posted on 2010-09-22
2
497 Views
Last Modified: 2013-11-14
EE,

We need to cluster SQL Server but have two different pieces of hardware, a Dell Poweredge R900 and a Dell Poweredge 6950. Running them on same hardware might be a best practice but considering same architecture, OS exc, could we get away with this configuration?

Thanks
0
Comment
Question by:snyderkv
2 Comments
 
LVL 22

Expert Comment

by:65td
Comment Utility
Should work, need to keep in mine loading of the app. in that node can handle the load.
Drivers to shared storage maybe an issue.
0
 
LVL 23

Accepted Solution

by:
Mysidia earned 500 total points
Comment Utility
The requirements are spelled out: http://technet.microsoft.com/en-us/library/cc732035%28WS.10%29.aspx
Although I think you are on highly dangerous ground, as  there is a world of difference between an R900 and a PE 6950, the CPUs aren't even similar, let alone other aspects of the system.

However, providing you are running Windows Server 2008 R2 or newer, you _might_ be able to get away with it,  and still have something supported as far as the OS is concerned  (your storage vendor is a separate matter), you will need to run the cluster validation wizard.       The cluster validation wizard is supposed to tell you that everything is OK,  or tell you that it deems there to be a problem with your cluster  (so that it would be unsupported)

I don't want to get your hopes up;  there is a fair chance the cluster wizard will tell you 'No' to this particular configuration, due to major differences between hardware nodes.

Note that for previous versions of Windows,  and Windows 2k/2003 in particular,  Microsoft had  a much stricter  quite long list of 'requirements'  for a cluster configuration to be supported, there was a specific list of supported cluster hardware HCL and supported configuration -- anything not on the list was not supported,  dissimilar nodes were considered unsupported in the past.

If you were thinking of doing this with an old version of Windows, that would be, well, unsupported, for sure.



But if you check that Technet document url above, see:
Cluster Configuration Changes

Change         Validation tests required
Adding a new node to the cluster                               Full
Adding a new node that uses dissimilar hardware        Full



Microsoft's recommendations noted in the document:  components of the storage stack should be identical across all nodes in the cluster.

That means, for example, Fiber channel HBAs,  or other devices used to connect to the shared storage.
They should be the same time, same hardware revision, same firmware version, and have the exact same locations on the PCI bus.

SQL failover clusters must use shared storage anyways, one of  the most significant issues is that the HBAs and HBA firmware are the same.


If you want specific guidance for your environment, however,  you want to seek one-on-one support/consulting from Microsoft, a Microsoft Partner,  or  Microsoft certified professional   with clustering expertise,  who can take a look at your plans, talk with you in detail,  and make recommendations,  revisions,   or  do the cluster implementation.

Obviously, the expense and administrative overhead required to implement clustering are high, only really worth it if you are trying to provide High Availability for business critical services.

And in such case, it may well be more than worth it for you to make sure the clustering is implemented correctly out the gate,  and you don't discover a design problem the first time you get a real failure.



'Type of server hardware to use'  is definitely not the only consideration or issue involved in properly designing and setting up clusters that will actually work like they are supposed to



0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Solid State Drive Performance Tips: Solid state storage technology is now a standard.  After testing and using several different brands and revisions of SSD's over the years I have put together a collection of tips,tools and suggestions that I ha…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now