SQLServer Always On availability groups

Ref: https://www.starwindsoftware.com/blog/always-on-availability-groups-vs-failover-cluster

1. 一定要安装WSFC吗？

是的，AG是基于WSFC实现

2. Cluster内的所有Node都有加入AD 域吗？

SQLServer 2016之前，是的。
SQLServer 2016开始支持workgroup cluster，节点可以不加入AD 域，但节点之间需要证书保证安全。

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver17

不使用AD的架构

具体配置步骤参考1

https://www.starwindsoftware.com/blog/sql-server-2016-basic-availability-groups-without-active-directory/

https://www.starwindsoftware.com/blog/deploying-sql-server-2016-basic-availability-groups-without-active-directory-part-2-configuring-sql-server/

具体配置步骤参考2

https://www.sqlshack.com/deploy-a-domain-independent-windows-failover-cluster-for-sql-server-always-on-availability-groups/

https://www.sqlshack.com/configure-a-sql-server-always-on-availability-group-on-the-domain-independent-failover-cluster/