question

VeenaSrinivas-0229 avatar image
0 Votes"
VeenaSrinivas-0229 asked usha-4706 published

Does Always On require a SQL Cluster ?

Hello,

Does Always ON configuration require both a SQL Instance Level Cluster and a WSFC ?

Or does it require only WSFC ?

Please clarify.

Thanks,
V


sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered usha-4706 published

Does Always ON configuration require both a SQL Instance Level Cluster and a WSFC ?

An Availability group neither requires SQL Server Failover cluster instance nor WSFC as MUST to configure it.

If you are talking about plain traditional AG, then yes it needs WSFC. But you should also know that starting from SQL Server 2017 you have Clusterless Availability group. So if someone is taking from SQL Server 2012 to 2016 WSFC is MUST for AG but starting from SQL Server 2017 like I said you can have AG without WSFC.

Regarding SQL FCI it is NOT a requirement at all.

Hope that clear things


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hi may i know what is plain traditional ag and it requires wsfc support.

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft edited

Hi @VeenaSrinivas-0229,

Yes, you can. An availability replica can be hosted by an FCI instance.
Deploying Always On availability groups requires a Windows Server Failover Cluster. And you can set up a second layer of failover at the server-instance level by implementing SQL Server an FCI together with the WSFC.

And there are some restrictions for using a SQL Server Failover Cluster Instance to host an availability replica:

  • The cluster nodes of an FCI can host only one replica for a given availability group. If you add an availability replica on an FCI, the WSFC nodes that are possible FCI owners cannot host another replica for the same availability group. Furthermore, every other replica must be hosted by an instance of SQL Server that resides on a different cluster node in the same Windows Server failover cluster.

  • FCIs do not support automatic failover by availability groups: FCIs do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can be configured for manual failover only.

  • Changing FCI network name: If you need to change the network name of an FCI that hosts an availability replica, you will need to remove the replica from its availability group and then add the replica back into the availability group.


Please refer to SQL Server Failover Cluster Instances (FCIs) and Availability Groups and Considerations for hosting an Availability Replica on an FCI for more details.
Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.