sql-server-clustering-for-dummies.pdf

(599 KB) Pobierz
SQL Server Clustering for
Dummies
Mark Broadbent
@retracement
mark.broadbent@sqlcloud.co.uk
tenbulls.co.uk
LinkedIn: http://linkd.in/gylT4I
Presentation and materials available from: http://bit.ly/gAqN32
A bit more about me!
•
More than 20 years in IT and more than 14 years using SQL Server. Have worked my many large
global corporations and SMEs such as Microsoft, Nokia, Hewlett Packard and Encyclopaedia
Britannica.
Presented at SQLBits 7 and due to speak at SQLRally 1 in Orlando
Microsoft Certified IT Professional Database Development SQL 2008
Microsoft Certified IT Professional Database Administrator SQL 2008
Microsoft Certified IT Professional Database Administrator SQL 2005
Microsoft Certified Application Developer (C# .net)
Microsoft Certified Database Administrator (SQL 2000)
Microsoft Certified Systems Engineer + Internet
Participate on #sqlhelp ,MSDN Forums, Stackoverflow & Serverfault.
Used to be active in the MS newsgroups until their demise :(
•
•
•
•
•
•
•
•
•
•
•
•
Run the LinkedIn groups
Linux Mint User Group http://www.linkedin.com/groups?gid=2989801
SQL Server Scripting http://www.linkedin.com/groups?gid=3033621
Agenda
•
Introduction to Clustering …What, why and who?
•
DEMO
•
Installation …Preparation, Validation and Installation
•
Administration …Problems and benefits
•
DEMO
•
Houston …we have a problem
Introduction
•
What is a SQL Cluster?
–
One or more “clustered” SQL Instances on one or more physical servers
running MS Windows
•
Why use one?
–
Single point of failure is the OS
–
Is Virtualization protecting the Virtual OS?
•
Who supports?
–
Diverse range of knowledge required, perhaps too much for a specialist DBA?
–
How do we monitor? Not all tools are cluster aware
–
Who controls the Cluster?
•
Is Clustering right for us?
–
Management expectation is that Clustering is 100% HA. It is not
–
Are skills in place, if not HA = Hopefully Available
–
Do your applications recover from unavailability?
Terminology
Terms can mean the same thing or sometimes tend to be used
interchangeably (often wrongly!) ...including by me. Depending upon
who you talk to they can cause confusion. They include:-
•
Cluster
•
Cluster Node
...Node...Server
•
Service
or
Application... Virtual Server...
Cluster Group
... Failover
•
•
•
•
•
•
Cluster... SQL Instance... SQL Server… and
*ahem* Server
Active/Passive…
Single Instance
...
Multi Instance
... N+n Cluster
Resources
(take your pick)
Private Network
...interconnect...internal
Public Network
...LAN (or whatever network is the one clients will
connect through facing!)
SAN... iSCSI target...
Shared Storage
… LUN... Partition... Volume... Disk
Quorum
... Voting Disk... Majority

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin