How to add new node to SQL failover cluster
-
Hi everyone,
We plan on adding a new passive node to an existing active/active two node production SQL 2000 SP3 cluster on Windows 2000 Advanced Server. Below are the steps (1-11) I’ve found so far to do this. I think I’ll have to run through these steps for each of the five virtual servers on this cluster.
First question: Can we do this without taking an outage of the existing production cluster?
Second question: Am I missing any steps?
Thanks for any insight you can provide!
---------------------------------------------------------------------------------------------
Adding or Removing a Cluster Node from the Virtual Server Definition
Another new feature of SQL Server 2000 failover clustering is the ability to add or remove a cluster node from a SQL Server virtual server definition. Adding nodes to the existing SQL Server virtual server definition performs all the necessary operations on the new nodes (including installing binaries, system components, and creating services) and performs the necessary modifications to the cluster configuration.
To add or remove a node
1.
Insert the SQL Server 2000 Enterprise Edition compact disc in your CD-ROM drive. Select Install SQL Server 2000 Components.
2.
Click Install SQL Server 2000 Components, click Install Database Server, and then click Next.
3.
On the Computer Name dialog box, select Virtual Server, and enter the name of an existing clustered instance of SQL Server 2000.
4.
On the Installation Selection dialog box, select Advanced options, and then click Next.
5.
On the Advanced Options dialog box, select Maintain a Virtual Server for Failover Clustering, and then click Next.
6.
On the Failover Clustering dialog box, click Next.
7.
On the Cluster Management dialog box, select the appropriate nodes to add or remove from the cluster, and then click Next when you are finished
8.
On the Remote Information dialog box, enter the user name and password for the domain administrator account used for the clustered instance of SQL Server 2000, and then click Next.
9.
When the process is complete, click Finish.
10. Apply SP3a - Run SP3a Setup on the newly added node. This will update to SP3a only the binaries on the new node.
Note If you run Setup from the node where the virtual server is running, you must reapply SP3a to all the nodes. You must also rerun the database upgrade scripts.
11. Apply other patches on the newly added node.
-
Not sure if I'm reading this right, but you are saying that you have a 2-node active/active cluster already running in production and you now want to add a 3rd node (passive) to this cluster. If I have this is right, and as you mention you are using SQL Svr 2000 Ent Ed with Win 2000 Adv Svr, then this isn't possible (unless MS have changed things and I missed it - happy for anyone to correct me on this
).With Win2000 Adv Svr you can have a max of 2 nodes in either active/active or active/passive configuration. Only Win2000 Datacenter will allow a 4-node cluster.
Hope this helps.
-
Pendragon999 you are reading it right! I have checked the SQL 2000 Sys Admin. book and it does say that Advanced Server only supports two nodes. So now I will have to have a little chat with our Window System Administrator.
Thanks for your feedback!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply