Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted May 17, 2002

SQL Server 2000 Administration in 15 Minutes a Week: Advanced Installations - Page 3

By Michael Aubert


Types of Clusters

Windows 2000 Advanced Server and Datacenter Server both provide Cluster Services including Network Load Balancing and Fault Tolerance. SQL Server 2000 is a fully "cluster aware" application that takes full advantage of the Fault Tolerant services that are provided by Windows. However, SQL Server 2000 can't take advantage of Network Load Balancing (or NLB). Network Load Balancing is designed for services such as ISS, HTTP, FTP, etc.

Each server in a Fault Tolerant Cluster is referred to as a node. Each node in the cluster must have access to a shared SCSI bus. Although each node's operating system is located on the individual servers, the shared applications (SQL Server in this case) are located on the SCSI bus that is accessible by all the nodes in the cluster.



To determine when a node has failed, nodes frequently send out what are called "heartbeat messages" to each other over the network. In the event that heartbeat messages are no longer detected from a specific node, the other servers in the cluster treat the node as failed and transfer the services from the failed node to another node. The actual process of detecting a failed node and transferring the services is a little more complicated, but I could write a whole other article on just that topic (and I may do just that, especially if anyone is interested).

There are two types of nodes in a Fault Tolerant Cluster:

- Primary Node: One per cluster
- Backup Node: One per cluster using Advanced Server or up to three if using Datacenter Server

The Primary Node is the system that does all the "work" in the cluster. The primary also controls the drives on the SCSI bus that contain the shared application. Unlike the Primary Node, Backup Nodes are only standbys who check to see if the Primary Node is still active. Backup Nodes have physical access to the SCSI bus, but do not access the drives unless they become the Primary Node.

The configuration of one primary doing all the work with one or more standbys is known as an Active/Passive configuration. If you are running large mission critical applications that can't afford any downtime or loss of performance, this is the configuration for you. However, to use an Active/Passive configuration on a large system is very expensive.

If you don't like the idea of having one server doing nothing most of the time or you can't afford all the servers you would need, you can use an Active/Active configuration. An Active/Active configuration is more like an Active/Passive and Passive/Active put together. In this configuration each server in the cluster acts like a Primary Node controlling part of the shared SCSI bus and also acts like a Backup Node. Using multiple instances of SQL Server you can then create a load-balancing effect (but not true load balancing). The downside to an Active/Active configuration is that in the event that one node fails, the backup node must perform the work of both nodes. This can result in degradation of performance especially if you don't have the hardware needed to support both applications on one server.




I have just scratched the surface on clustering. Clustering is a neat topic and if you would like to learn more have a look at the following links:

http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
http://www.microsoft.com/windows2000/techinfo/howitworks/cluster/clusterarch.asp


Page 4: Service Accounts


 » See All Articles by Columnist Michael Aubert



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date