Quorum in Failover Cluster | How to Change Disk Witness in Quorum from one drive to other || Ms SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ก.ย. 2024
  • In the Windows Failover Cluster, we have two or more cluster nodes, and these nodes communicate with each other on the UDP port 3343. Suppose due to some unforeseen circumstances; nodes cannot communicate with each other. In this case, all cluster nodes assume that they need to bring the resources online. Multiple nodes might try to bring the same resource online at the same time, but it is not possible to do so. This situation is called a Split-Brain situation, and we never want to be in this situation. We might face data corruption issues in this case.
    We can avoid a split-brain scenario in Windows Failover Cluster by bringing the resources on a single node. Windows cluster achieve this by implementing a voting mechanism. Quorum checks for the minimum number of votes required to have a majority and own the resources
    Understand Quorum types : techcommunity....
    Intro of windows failover cluster: • Windows Failover Clust...
    Configuration of Windows failover clustering :
    • Windows Failover clust...

ความคิดเห็น • 15

  • @supriyabhagavatula8999
    @supriyabhagavatula8999 3 ปีที่แล้ว +1

    Videos are amazing and easy to understand from scratch....please cover Replication topic also....

    • @righttolearnbk
      @righttolearnbk  3 ปีที่แล้ว

      Thank you.
      I will cover replication, you may expect it in few weeks

  • @bhys570
    @bhys570 11 หลายเดือนก่อน

    Very useful channel 😊

  • @tharathumma9015
    @tharathumma9015 ปีที่แล้ว +1

    Sir please post a video on SQL Server Failover Cluster installation also.

    • @righttolearnbk
      @righttolearnbk  ปีที่แล้ว

      I don't have the machine setup in my home environment. But I will try to purchase machine from cloud and try to do it if possible. And unfortunately I cannot show it in my work environment due to security policies.

  • @paragnimbhore9963
    @paragnimbhore9963 6 หลายเดือนก่อน

    Great video please make video for combine operation for failover cluster and always on

  • @nilsonandresurrestigonzalez
    @nilsonandresurrestigonzalez ปีที่แล้ว

    Hello, tysm for the video, I have a question, if my cloud witness is in Azure(storage account), do you know how I can find out within the cluster configuration, how to look at that resource to which I am connecting in Azure?

  • @ganavigowda1
    @ganavigowda1 8 หลายเดือนก่อน

    So helpful, continue to do these kinda vedios pls. Replication convering topics too

  • @AlexN0me11
    @AlexN0me11 3 ปีที่แล้ว

    What if you only have 3 nodes running a SQL availability group with no shared disks. There are two that are in one subnet and one that is in another subnet?

  • @bhys570
    @bhys570 11 หลายเดือนก่อน

    You deserves millions of subscribers

  • @kirankumar-np7tc
    @kirankumar-np7tc 6 หลายเดือนก่อน

    Quarum is no need in Linux environment ?

  • @Mr_expert_gameplay
    @Mr_expert_gameplay ปีที่แล้ว

    Good 👍

  • @a.useronly2266
    @a.useronly2266 ปีที่แล้ว

    Great

  • @myvlogs3590
    @myvlogs3590 3 ปีที่แล้ว

    Do replication also 👌👌👌👌

  • @aniltarimineni3093
    @aniltarimineni3093 3 ปีที่แล้ว

    Super brother