alwayson 增加节点
In this series of AlwaysOn High availability configuration in SQL Server, I am going to write step by step articles from pre-requisite to end configuration. This may help beginners who are going to configure for the first time.
在SQL Server的AlwaysOn高可用性配置系列中,我将逐步编写从必备组件到最终配置的文章。 这可能会对初次配置的初学者有所帮助。
AlwaysON is one of the High availability options in SQL Server which is used for a Disaster recovery solution. To configure AlwaysOn High availability, we should know some basic knowledge of Windows Server.
AlwaysON是SQL Server中用于灾难恢复解决方案的高可用性选项之一。 要配置AlwaysOn高可用性,我们应该了解Windows Server的一些基本知识。
To follow this article, you should be aware of basic things like Domain controller, Public, Private network, Subnet etc.
要阅读本文,您应该了解域控制器,公共网络,专用网络,子网等基本内容。
目的 (Objective)
In this article, we are going to learn, how to perform Domain controller and domain client nodes set-up and add two or more windows servers as a node into the domain controller domain and cluster by moving windows server node from local group to domain group. Windows server is a Microsoft operating system which is used as Platform to host SQL Server functionality.
在本文中,我们将学习如何执行域控制器和域客户端节点设置 ,以及如何通过将Windows服务器节点从本地组移动到域组来将两个或多个Windows服务器作为节点添加到域控制器域和群集中。 Windows服务器是Microsoft操作系统,用作承载SQL Server功能的平台。
There are many pre-requisites which we need to complete to configure AlwaysOn windows server, which we will explore in upcoming articles. Here we will see first pre-requisite that, it requires one domain controller and other windows nodes which will be part of AlwaysON, as a domain client
配置AlwaysOn Windows服务器需要完成许多先决条件,我们将在后续文章中进行探讨。 在这里,我们将看到第一个前提条件,它要求一个域控制器和其他Windows节点(将成为AlwaysON的一部分)作为域客户端
In this article, we are going to use three windows servers one domain controller and two other nodes as domain client.
在本文中,我们将使用三个Windows服务器(一个域控制器和两个其他节点)作为域客户端。
Let’s say we have below server configuration:
假设我们有以下服务器配置:
Servers |
Domain Controller (Node 1) |
SQL1 (Node 2) |
SQL2 (Node 3) |
Public IP |
35.193.27.200 |
35.188.66.201 |
35.238.35.203 |
Internal IP |
10.128.0.2 |
10.128.0.3 |
10.128.0.4 |
Default Gateway |
10.128.0.1 |
10.128.0.1 |
10.128.0.1 |
伺服器 |
域控制器(节点1) |
SQL1(节点2) |
SQL2(节点3) |
公共IP |
35.193.27.200 |
35.188.66.201 |
35.238.35.203 |
内部IP |
10.128.0.2 |
10.128.0.3 |
10.128.0.4 |
默认网关 |
10.128.0.1 |
10.128.0.1 |
10.128.0.1 |
As per requirement, we will make Node 1 as Domain controller and Node2 and Node3 as a domain client.
根据要求,我们将节点1设为域控制器,将节点2和Node3设为域客户端。
A domain controller is the main administrator server/Computer where we manage all domain client computers, Users and Groups. Also, most important, Cluster configuration to add all client nodes into cluster happen at domain controller in Failover Cluster Manager.
域控制器是主要的管理员服务器/计算机,我们在其中管理所有域客户端计算机,用户和组。 同样,最重要的是,将所有客户端节点添加到群集的群集配置在故障转移群集管理器中的域控制器上进行。
1.设置域控制器: (1. Set-up Domain Controller:)
Windows server is a member of either two types WORKGROUP and domain. We can check whether windows server is on WORKGROUP or domain as below
Windows服务器是WORKGROUP和domain两种类型的成员。 我们可以检查Windows服务器是否在WORKGROUP或域上,如下所示
Go to Control Panel>System and Security>System
转到控制面板>系统和安全性>系统
As we can see, windows server node 1 is on WORKGROUP, so we need to move it from WORKGROUP to domain.
如我们所见,Windows服务器节点1位于WORKGROUP上,因此我们需要将其从WORKGROUP移至域。
To move a computer from a local system to Domain system, we need to install two important features Active directory domain services (AD DS) and Failover Clustering Feature.
要将计算机从本地系统移至域系统,我们需要安装两个重要功能: 活动目录域服务 (AD DS)和故障转移群集功能。
Active Directory and domain services stores information of users, computers. Failover cluster means servers which are added into cluster i.e. group can interchange their roles and functionality