sql server on a cluster n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SQL Server on a Cluster PowerPoint Presentation
Download Presentation
SQL Server on a Cluster

Loading in 2 Seconds...

play fullscreen
1 / 19

SQL Server on a Cluster - PowerPoint PPT Presentation


  • 85 Views
  • Uploaded on

SQL Server on a Cluster. Experiences Mike FITZSIMON SYSTEMS ARCHITECT F ITZSIMON IT C ONSULTING PTY LTD. Why use SQL Server on a Cluster?. High Availability Fault Tolerance (?) Failback Manageability Scalability (?). Hardware Architecture – Single Tier. Web Server

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL Server on a Cluster' - lora


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
sql server on a cluster

SQL Server on a Cluster

ExperiencesMikeFITZSIMONSYSTEMSARCHITECTFITZSIMON IT CONSULTING PTY LTD

why use sql server on a cluster
Why use SQL Server on a Cluster?
  • High Availability
  • Fault Tolerance (?)
  • Failback
  • Manageability
  • Scalability (?)

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture single tier
Hardware Architecture –Single Tier
  • Web Server
  • Business Logic COM Components
  • SQL Server

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture two tier
Hardware Architecture –Two Tier

Web Server

Business Logic COM Components

SQL ServerDatabase Server

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture three tier
Hardware Architecture –Three Tier

WebServer

Business Logic COM Components

SQL ServerDatabase Server

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture scalable three tier
Hardware Architecture –Scalable Three Tier

SQL ServerDatabase Server

Web Server Farm

Application Server Farm

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

h w architecture ozevents com
H/w Architecture -OzEvents.com
  • Router distributes http requests
  • 2-Server Web Farm(Test site on one server)
  • SQL Server(Production & Test databases)
  • Exchange Server

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture scalable three tier1
Hardware Architecture –Scalable Three Tier

SQL ServerDatabase Server

Single point of failure?

Web Server Farm

Application Server Farm

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture cluster server

LAN

Server A

Server B

SCSI

SCSI

Private LAN

Shared SCSI

RAID Applications & Data

Hardware Architecture - Cluster Server
  • Two or more Servers
  • Private LAN(heartbeat, <500ms ping)
  • Shared SCSI bus (separate to System SCSI bus)
  • Applications & Data on RAID

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

ims locations
IMS Locations

Brisbane

  • Cluster Servers in each State Office
  • Frame Relay Service

Sydney

Melbourne

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

high availability cluster servers
High AvailabilityCluster Servers
  • IBM Netfinity 5500 Servers
  • Physical machines named\\Heaven and \\Hell
  • Virtual machines named\\BneSQL and \\BneIIS
  • Required 4 IP addresses !

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

high availability cluster servers1
High AvailabilityCluster Servers
  • RAID-1 Mirrored internal disk drives
  • Can be used as an emergency backup during a system upgrade

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

high availability cluster servers2
High AvailabilityCluster Servers
  • External RAID array
  • StorageTek
  • Raid-1 9Gb Quorum Disk(persistent arbitration)
  • Raid-5 18 Gb Data disks

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

high availability cluster servers3

Dual Network adaptors

Dual Power supplies

High AvailabilityCluster Servers
  • External RAID array:

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

hardware architecture cluster server1

LAN

Server A

Server B

SCSI

SCSI

Private LAN

Shared SCSI

RAID Applications & Data

Hardware Architecture - Cluster Server
  • Normal Active/Active configuration
  • Server A: IIS & MTS Resource Groups
  • Server B: SQL Resource Group
  • Web pages and SQL MDF files on RAID

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

multi node clusters
Multi-Node Clusters
  • Still need only two NICs per machine(one for public network, one for private network)
  • Need a Hub
  • To support at least 4-nodes, needWindows Server 2003 Enterprise Edition or Windows Server 2003 Datacenter Edition
  • Windows Clustering is installed by default;configure a cluster by startingCluster Administrator or Cluster.exe

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

writing your own cluster aware application
Writing your own Cluster-Aware Application
  • LooksAlive(By default, SQL calls this every 5 seconds)
  • IsAlive(By default, SQL calls this every 60 seconds)

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

clustering resources
Clustering Resources
  • Quorum Drive Configuration Information http://support.microsoft.com/?id=280345
  • Available Features in Windows Server 2003 Clusters http://support.microsoft.com/?id=278007
  • Step by step guide to install a 2000 Cluster:http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

questions
Questions
  • Mike FitzsimonMike@Fitzsimon.com.au
  • This ppt available fromwww.fitzsimon.com.au/qmsdnug

FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au