SQL Server 2000 Clustering

1
SQL Server 2000 Clustering

• Dave Fackler

2
Agenda

• Windows 2000 Clustering
• SQL Server 2000 Clustering
• Implementation Tips

3
Windows 2000 Clustering

• Shared disk approach
• Windows 2000 Advanced Server
• Two nodes
• Four nodes possible with Data Center
• Install using Cluster Service
• Manage using Cluster Administrator
• Resources
• Groups

4
Standard Win2K Cluster
5
SQL Server 2000 Clustering

• SQL Server 2000 Enterprise Edition
• Install using SQL Server Setup
• Create virtual server
• Single instance or multi-instance (not
  active-passive or active-active)
• Manage using Enterprise Manager

6
Single Instance SQL2K Cluster
7
After Failover
8
Multi-Instance SQL2K Cluster
9
Implementation Tips

• Plan, plan, plan!
• Plan shared disk space
• Nothing should go on the Quorum drive
• Recommend RAID-1 for Quorum
• Recommend RAID-10 (or at least
• RAID-5) for SQL database files
• Recommend RAID-1 for SQL log files
• Need at least 2237 drives!
• Dont skimp on hardware

10
Implementation Tips

• Plan, plan, plan!
• Plan network setup
• Public network IP addresses for cluster nodes,
  the cluster itself, and each SQL Virtual Server
• Private network for cluster nodes
• WINS and DNS services running
• Create service accounts beforehand
• Dont forget MSDTC setup

11
Implementation Tips

• Test, test, test!
• Cluster failover
• Hardware failures
• Network cards and cables
• Shared disk arrays and cables
• Entire node shutdowns
• SQL Server and application failures

12
Agenda

• Windows 2000 Clustering
• SQL Server 2000 Clustering
• Implementation Tips
• But wait what about Analysis Services, DTS, etc?
• All possible, but another presentation