Sqlserver Always On
Structure decomposition, easy to understand.
It adopts the mode of 2 host nodes and 1 file arbitration node.
sqlserver host a: host_a ip: 192.168.1.1 sqlserver host b:host_b: 192.168.1.2 filehost: 192.168.1.3
Create Cluster:Cluster_name ip: 192.168.1.5
Create Role: Role_name ip: 192.168.1.6
Create node: point_name1 ip: 192.168.1.7 point_name2 ip;192.168.1.8 Node IP can be the same as host IP.
Create Database Availability Group Listeners Listener_name: 192.168.1.10 Port is 1433
After completion, pay attention to shrinking the backup of log files, otherwise disk space will be used quickly.
