windows clustering and quorum basics
Post on 20-Jan-2017
467 Views
Preview:
TRANSCRIPT
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION
Drag picture to placeholder or click icon to addDrag picture to placeholder or click icon to add
Presented by Yogesh Arora
SQL Community Session – Delhi NCR
Basics of windows Clustering & Quorum Models
1. Basics of windows Clustering2. Quorum Models
Welcome.Microsoft Services helps businesses around the world maximize their return on investment in Microsoft products and technologies.
05/01/2023 2
05/01/2023 3
Basics of windows Clustering
The word Cluster itself is self-descriptive—a bunch or group. When two or more than two computers are connected to each other by means of a network and share some of the common resources to provide redundancy or performance improvement, they are known as a cluster of computers
Clustering is usually deployed when there is a critical business application running that needs to be available 24 X 7 or in terminology—High Availability.
MS Windows server Standard, Enterprise and Datacentre edition supports failover clustering
SQL Server Clustering is built on top of Windows Clustering, which means before we go about installing SQL Server clustering, we should have Windows clustering installed
05/01/2023 4
Differences between Windows 2008 and 2012 cluster
Windows 2008 Windows 2012
maximum Limit 32 nodes maximum limit of 64 nodes per cluster
No Cluster Aware updation
No Geo Clusters
No File and storage Services
You need to have Star wind or SCSI interface for Shared disks
Inbuilt ISCSI Interface
Mo
05/01/2023 5
Clustering Common Terms
Active/Passive Cluster Active/Active Cluster Public Network: Private Network aka Heartbeat Shared Disk Array Quorum Cluster Name: Cluster IP Cluster Resource Type Cluster Account Cluster Group Cluster Name for Virtual SQL
Server IP for Virtual SQL Server
05/01/2023 6
Quorum Configuration
It helps ensure that the failover cluster can start properly or continue running when the active cluster membership changes.
Configuring a witness vote helps the cluster sustain one extra node down in certain configurations.
Cluster quorum configuration helps ensure that only one of the subsets continues running as a cluster in case a subset cannot communicate with another subset
05/01/2023 7
Overview of the quorum configuration options
Use typical Settings
Add or change the quorum Witness
Advanced quorum Configuration and witness
selection
05/01/2023 8
Overview of the quorum configuration options
Impact of data distribution
05/01/2023 9
Add or remove Quorum witness
05/01/2023 10
Overview of the advanced quorum configuration options
Sort
05/01/2023 11
FAQ’s Question: What will happen to the data that is being accessed? Question: What about clients that were connected previously? Does the failover mean that developers will have to modify the connection string?
05/01/2023 12
top related