Our previous article introduced the configuration of SQL Server Failover cluster, and today we continue on to an unfinished configuration introduction, ready to add a node, and then configure the implement AlwaysOn configuration to implement SQL Server Failover cluster+ AlwaysOn achieves single point of failure and high availability for SQL Server, SQL Server Failover Cluster has been configured, then we configure ALwaysOn, we prepare a SQL Server, But also need to join the cluster node, we are below the configuration of the previous section diagram;
Hostname:dc1
Role:dc
ip:192.168.5.20
Domain:ixmsoft.com
Hostname:iscsi
ip:192.168.5.38
Role:storage
Hostname:s1
Role:sql Server 2016
ip:192.168.5.41
Hostname:s2
Role:sql Server 2016
ip:192.168.5.42
Hostname:ao1
Role:sql Server 2016
ip:192.168.5.43
Sql-cluster
192.168.5.46
SQLCluster
192.168.5.47
Ha-lp1
listenip:192.168.5.48
We first install the cluster failover role on the new node
We are now adding nodes to the cluster nodes, adding a third SQL to the node
Enter the name of the new node
Validation by
Directly increases the node after the test passes
Node Additions completed
We look at the node information again
We then install the standalone SQL instance
We install functional roles
You must name an instance because a default instance has already been created in the cluster, and if you have installed a SQL cluster instance in the cluster, then when you install the SQL instance on the nodes in the cluster (regardless of the stand-alone
or clustered), you can no longer use this instance name. That means you've already installed clustered SQL on cluster nodes 1, 2.
Default instance, you can no longer install a standalone SQL default instance on node 3. In this case, you can select the node
On 3, install a SQL named instance,
Define account information
Server configuration information
Data Catalog we can define locally
Installation Complete
After node three is installed, we find that the service does not have a port, the default amount of SQL Port is 1433, so we modify the default port---SQL Server configuration Management
SQL Server Failover cluster+ ALwaysOn (ii)
