Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fonkberry
Starting Member
5 Posts |
 Posted - 2005-10-26 : 11:50:31
|
| I am looking for information on building a 4 node, multi-instance, SQL cluster on Win2K3 Datacenter server. I've consulted BOL, google, and Microsoft's "techinfo" pages for Datacenter server clustering, but everytime I think I'm going to get some good information, I end up with info on a default, 2-node cluster setup. Any guidence, links, etc. would be highly prized.Thanks very much. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-26 : 12:16:43
|
| As far as the 3 and 4 node clustering goes, it is really the same as a 2 node cluster. You just need to build the cluster and bring all the nodes into it at first. You install SQL Server after the cluster is up and running. This is exactly the same procedure as a 2 node cluster.Also, consulting is bundled into the price of datacenter server. It is also extremely restrictive, so you will want to look into what running datacenter edition really means. You will be limited to the software that can be installed on the box (3rd party packages, patches, etc.)NOTE:1. The maximum number of nodes for a SQL Server 2000 cluster is 4. 2. You will run into issues if you are not installing from an SP3a based installation. see this KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;815431-ec |
 |
|
|
Fonkberry
Starting Member
5 Posts |
Posted - 2005-10-26 : 12:50:12
|
| Thanks for replying "eyechart". I've built 2-node clusters for SQL and Exchange in the past and it's pretty strait forward. I guess I was thinking of the private network "heartbeat". With 2 nodes a cross-over cable is used for the private net. Do I use a hub/switch for a 4 node cluster? Where can I find specifics on this configuration in terms of NIC settings, etc? THanks again. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-26 : 13:22:08
|
quote:
Originally posted by Fonkberry
Thanks for replying "eyechart". I've built 2-node clusters for SQL and Exchange in the past and it's pretty strait forward. I guess I was thinking of the private network "heartbeat". With 2 nodes a cross-over cable is used for the private net. Do I use a hub/switch for a 4 node cluster? Where can I find specifics on this configuration in terms of NIC settings, etc? THanks again.
you would use a switch or a hub. I would actually prefer a hub, but they are somewhat hard to come by these days.There is a KB article from microsoft that details the recommended heartbeat settings. here is the link http://support.microsoft.com/default.aspx?scid=kb;en-us;258750-ec |
|
|
|
|
|
|
|
|
SQL Clustering Info - More than 2 nodes please.