1 Introduction to ClusteringThis session is intended to give an overview of Failover Clustering with regards to SQL Server Chad Churchwell Premier Field Engineer – SQL Server Microsoft Corporation @chadchurchwell |
2 About Me Premier Field Engineer with Microsoft SQL Saturday PresenterHigh Availability Disaster Recovery Replication SQL Saturday Presenter JSSUG 12+ years experience as DBA Author for
3 Agenda Introduction Clustering ArchitectureComponents in Failover Cluster Quorum Models Networks for clustering What is differences between WSFC/FCI? Installing SQL Server on a cluster Administering SQL Server on a cluster
4 SQL Server Failover ClusterWhat is a “SQL Server Cluster”?? Protects From… Local resource failure (except disk) Outages for patching Local HA Does not protect from… Corruption Deleted data SAN outages (Shared Storage)
5 SQL Server Cluster Architecture
6 SQL Clustering ComponentsTwo or more nodes Shared Storage Networking Quorum CNO (Cluster Name Object) CLUSTERNAME$ in AD Cluster IP and Network Name SQL Virtual Network Name and IP SQL Clustered Installation
7 SQL Clustering Quorum ModelsConsiderations ODD/EVEN Local/Remote
8 Quorum – New in Server 2012/R2Dynamic Quorum Introduced in Windows Server 2012 Implements “Last Man Standing” Dynamically removes voting rights Dynamic Witness Introduced in Windows Server 2012 R2 Cluster decides whether to use witness
9 Networking for SQL ClustersPublic Normal LAN connectivity Heartbeat Used for Cluster communications between nodes Storage (iSCSI) TCP connectivity to iSCSI storage
10 WSFC vs FCI WSFC FCI Windows Server Failover ClusterOS Level Component Requires “Failover Clustering” OS feature Pre-requisite for SQL Cluster FCI Failover Cluster Instance Clustered SQL Server Installation Built on top of WSFC
11 Installing a SQL Server ClusterPrerequisites Enable “Failover Clustering” OS feature Present Shared Storage to all nodes Pre-stage cluster objects in AD (if needed) Ensure NIC’s for all networks are configured Create a WSFC in Windows Server Obtain successful cluster validation report Perform SQL Server Clustered Installation “Add Node” to all secondary nodes
12 Installing a SQL Server Cluster
13 Installing a SQL Server Cluster
14 Administering a SQL Server ClusterUse “Failover Cluster Manager” For failover Look at cluster resources and dependencies What happens during failover Primary node SQL services are stopped Secondary SQL services start and gain control of shared storage All system/user DB’s live on shared storage
15 Administering a SQL Server Cluster
16 New Features in SQL Server 2012Flexible Failover Policy Levels 0-5 Default of 3 LooksAlive/IsAlive replaced sp_server_diagnostics Support for multi-subnet clusters IP Binding using OR algorithm
17 Flexible Failover in SQL Server 2012
18 DEMO Questions? Chad Churchwell SQL Premier Field Engineer - Microsoft Twitter: @chadchurchwell