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

Sdílet
Vložit
  • čas přidán 8. 12. 2020
  • 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.microsoft.com/t...
    Intro of windows failover cluster: • Windows Failover Clust...
    Configuration of Windows failover clustering :
    • Windows Failover clust...

Komentáře • 15

  • @ganavigowda1
    @ganavigowda1 Před 6 měsíci

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

  • @bhys570
    @bhys570 Před 8 měsíci

    You deserves millions of subscribers

  • @supriyabhagavatula8999
    @supriyabhagavatula8999 Před 3 lety +1

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

    • @righttolearnbk
      @righttolearnbk  Před 3 lety

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

  • @bhys570
    @bhys570 Před 8 měsíci

    Very useful channel 😊

  • @paragnimbhore9963
    @paragnimbhore9963 Před 3 měsíci

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

  • @AlexN0me11
    @AlexN0me11 Před 3 lety

    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?

  • @aniltarimineni3093
    @aniltarimineni3093 Před 3 lety

    Super brother

  • @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?

  • @Raj-rj1qp
    @Raj-rj1qp Před rokem

    Good 👍

  • @a.useronly2266
    @a.useronly2266 Před rokem

    Great

  • @kirankumar-np7tc
    @kirankumar-np7tc Před 4 měsíci

    Quarum is no need in Linux environment ?

  • @tharathumma9015
    @tharathumma9015 Před rokem +1

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

    • @righttolearnbk
      @righttolearnbk  Před 11 měsíci

      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.

  • @myvlogs3590
    @myvlogs3590 Před 3 lety

    Do replication also 👌👌👌👌