Sunday, February 19, 2012

Clustering Nodes

Can I create a 2-node cluster using servers with different CPU configs? I have a dual CPU in one node and a quad cpu in another that I want to be able to cluster SQL 2000.
TIA,
Ken
Possible, Yes.
Recommended, No.
FYI, you can't just pick two machines at random and create a cluster.
First, the machines must be on the Cluster HCL (Hardware Compatability
List). Second, they must be installed and configured by a certified cluster
vendor. Otherwise, you may not be able to obtain support for your cluster.
(Or at least the support stops at 'You need to be on a certified cluster'.)
If all you are interested in is a cluster for testing and training, then go
right ahead and grab whatever is lying around. If you want a cluster to be
the centerpiece of a High-Availability database solution, then you need to
go with a certified install.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ken Krause" <anonymous@.discussions.microsoft.com> wrote in message
news:D0EA9DE7-3445-45A7-8F4A-EB397C94CBFE@.microsoft.com...
> Can I create a 2-node cluster using servers with different CPU configs? I
have a dual CPU in one node and a quad cpu in another that I want to be able
to cluster SQL 2000.
> TIA,
> Ken
|||Thanks for the response. I have a clustered pair of nodes with all hardware on the HCL and have been running without any clustering problems whatsoever. However, the database at the center of this web-based app is running into cpu bettlenecks which causes
extremely poor performance. This has been building for a few months now. I want to go to a quad cpu to eliminate this bottleneck, but can only get the funds for one server at a time. I need the performance right now, but want to keep the clustering for a
vailability.
|||Here's an article which describes the tolerable difference between your
cluster nodes and still maintain support for your cluster:
http://support.microsoft.com/default...b;en-us;814607
It'll work and it's supported, though certainly not recommended.
Regards,
John
"kmkrause2" <anonymous@.discussions.microsoft.com> wrote in message
news:055EEAD5-EB16-438B-B9AC-045F2EC9415C@.microsoft.com...
> Thanks for the response. I have a clustered pair of nodes with all
hardware on the HCL and have been running without any clustering problems
whatsoever. However, the database at the center of this web-based app is
running into cpu bettlenecks which causes extremely poor performance. This
has been building for a few months now. I want to go to a quad cpu to
eliminate this bottleneck, but can only get the funds for one server at a
time. I need the performance right now, but want to keep the clustering for
availability.
|||Thanks for the link, John. Now if only the server would get here. It seems DHL has lost it. It shipped from Vegas and hasn't been documented since it left there 2 days ago. Probably has been stolen, or maybe I've been watching too much Soprano's.

No comments:

Post a Comment