1 / 19

SQL Server on a Cluster

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

lora
Download Presentation

SQL Server on a Cluster

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server on a Cluster ExperiencesMikeFITZSIMONSYSTEMSARCHITECTFITZSIMON IT CONSULTING PTY LTD

  2. Why use SQL Server on a Cluster? • High Availability • Fault Tolerance (?) • Failback • Manageability • Scalability (?) FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  3. Hardware Architecture –Single Tier • Web Server • Business Logic COM Components • SQL Server FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  4. Hardware Architecture –Two Tier Web Server Business Logic COM Components SQL ServerDatabase Server FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  5. Hardware Architecture –Three Tier WebServer Business Logic COM Components SQL ServerDatabase Server FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  6. Hardware Architecture –Scalable Three Tier SQL ServerDatabase Server Web Server Farm Application Server Farm FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  7. 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

  8. 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

  9. 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

  10. IMS Locations Brisbane • Cluster Servers in each State Office • Frame Relay Service Sydney Melbourne FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  11. 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

  12. 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

  13. 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

  14. Dual Network adaptors Dual Power supplies High AvailabilityCluster Servers • External RAID array: FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

  15. 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

  16. 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

  17. 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

  18. 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

  19. Questions • Mike FitzsimonMike@Fitzsimon.com.au • This ppt available fromwww.fitzsimon.com.au/qmsdnug FitzsimonIT CONSULTING PTY LTD www.fitzsimon.com.au

More Related