Shulou(Shulou.com)06/01 Report--

Determine the arbitration mode

When configuring a failover cluster, if the cluster nodes are odd, use most nodes; if the cluster nodes are even, use majority nodes and file sharing (configure a shared folder, each node can access the shared folder)

Because it is an even number of nodes (sql01 and sql02), select the majority node and file sharing mode

two。 Install failover cluster, sql01 and sql02 are both installed (domain account can be used to log in and install. If it is a local account, log in again with domain account after installation)

Check Failover Clustering

Check to restart if necessary

Configure a failover cluster

Click Failover Cluster Manager

Click Validate Configuration...

Click Browse...

Click Advanced...

Click Find Now

Select SQL01,SQL02

Click Finish when the verification is complete, as follows

Enter the cluster name: sqlalwayson, and configure IP:192.168.0.110

Uncheck Add all eligible storage to the cluster

Click Finish, and the cluster is created successfully, as follows

Configure arbitration

Create a shared folder before configuration: create a quorumshare folder in DC and set up sharing

Sql01 and sql02 verify access and read and write

Arbitration configuration, More Actions- > Configure Cluster Quorum Settings...

Select Select the quorum witness

Select Configure a file share witness

Enter the share path:\ SQLDC\ quorumshare

Click Finish

At this point, the failover cluster configuration is complete

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.