SQLServer Alwayson Without Domain and Samba As Witness Node

Manual Doc

1. 准备阶段

1- 首先,开出两台 Windows 虚机及1台 Linux 虚机; 确认在同一个VPC下,相互之间网通。

2- 分别关闭防火墙;如有黑白名单,注意修改

3- 分别修改群集节点主机名称,Windows 如需重启,请重启使之生效

```
sudo hostnamectl set-hostname <host-name>
```

4- 配置主机域名映射:

Linux - /etc/hosts
Windows- C:WindowsSystem32driversetchost

10.0.44.44      fc-cluster-1.xxx.com
10.0.44.43      fc-cluster-2.xxx.com
10.0.44.41      fc-cluster-witness.xxx.com

10.0.44.44      fc-cluster-1
10.0.44.43      fc-cluster-2
10.0.44.41      fc-cluster-witness

10.0.44.45      wfsc-cluster-45

5- 创建群集

(请在Windows 两个节点中执行)
new-itemproperty -path HKLM:SOFTWAREMicrosoftWindowsCurrentVersionPoliciesSystem -Name LocalAccountTokenFilterPolicy -Value 1
(在主节点执行即可)
New-Cluster -Name FCCluster -node i-khtaKKE93Q,i-MvUIjVMVxf -AdministrativeAccessPoint Dns -StaticAddress 172.16.16.112 (cluster的ip)

2. Linux Centos 安装Samba

yum install samba samba-client
cp  /etc/samba/smb.conf /etc/samba/smb.conf.bak
vi  /etc/samba/smb.conf
mkdir -p /samba/wfsc-cluster-45
sudo chmod  -R 0755 /samba/wfsc-cluster-45
sudo groupadd sambashare
sudo useradd -M -d /samba/wfsc-cluster-45 -s /usr/sbin/nologin -G sambashare wfsc-cluster-45
sudo chown wfsc-cluster-45:sambashare /samba/wfsc-cluster-45
sudo smbpasswd -a wfsc-cluster-45
sudo smbpasswd -e wfsc-cluster-45
systemctl restart smb.service
systemctl restart nmb.service

verify: smbclient //localhost/wf