April 4, 2002 at 3:23 pm
Guys,
I am a litlle bit confused. I've read about installation of SQL 2000 in a cluster environment and I have a question:
for an active/pasive configuration I have to install in both nodes SQL server or I have to install it only from one node to one of the shared drives and in the other node I have to install only the client tools locally to be able to use Enterprise manager from both nodes.
Please clear my mind
Thanks,
Adrian
April 4, 2002 at 6:51 pm
This is a statement from the whitepaper on failover clusters found at http://www.microsoft.com/sql/techinfo/administration/2000/failovercluster.asp. But the fact is each node has server installed but left in a wait state.
With instances, come two new concepts for failover clustering:
·Single instance cluster: replaces an active/passive cluster. A single instance cluster means there is one SQL Server 2000 virtual server installed.
·Multiple instance cluster: replaces an active/active cluster. A multiple instance cluster is one in which there is more than one SQL Server 2000 virtual server installed. Because of the way the implementation of clustering is different with SQL Server 2000, using the active/active terminology does not really apply.
Single-Instance Cluster
A single-instance cluster has only one active instance of SQL Server owned by a single server node, and all other nodes of the cluster are in a wait state. Another node is enabled in the event of a failure on the active node, or during a manual failover for maintenance.
Multiple-Instance Cluster
A multiple-instance cluster has up to four server nodes and supports up to 16 instances (1 default, 15 named or 16 named). Each SQL Server 2000 virtual server requires its own disk resources that cannot be used by other instances. These disk resources are the logical drive names (for example, drive F:\) used by SQL Server on which to store data and log files. Separate physical disk sets are needed to make up the logical drive, unless your disk subsystem supports multiple logical drives on one physical drive set. SQL Server in a clustered environment also behaves differently from a stand-alone named instance in relation to IP ports. During the installation process, a dynamic port that may be something other than 1433 is configured, and that port number is reserved for the instance. In a failover cluster, multiple instances can be configured to share the same port, such as 1433, because the failover cluster listens only to the IP address assigned to the SQL Server virtual server, and is not limited to a 1:1 ratio. However, for security and potentially increased availability, you may want to assign each virtual server to its own unique port of your choice or leave it as it was configured during installation.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply