Forum Discussion

Bayas1200's avatar
Bayas1200
Copper Contributor
Jan 08, 2024

Cluster

Is clustering support in SQL Server?

  • YuriyZaletskyy's avatar
    YuriyZaletskyy
    Copper Contributor

    MS SQL supports clustering.

    First of all it supports Failover Cluster Instances. That is applicable to single SQL server instance across multiple Windows Server Failover Clustering ( WSFC ) nodes. In case if one of the nodes crashes, SQL server automatically passes execution to another one.

    Second option is Always On Availability Groups. In this case, each availability group consists of primary replica and one or more secondary replicas. In case of crash, secondary replica becomes primary one. 

    If to compare WSFC vs Always on, then Always on doesn't require shared storage.

  • Yusuf Anis's avatar
    Yusuf Anis
    Copper Contributor

    Big time yes. You can get the HA of SQL Instances using SQL FCI or Database specific using SQL AOAG. Later also helps your distribute RO & RW workloads.  

Resources