一、故障转移群集的概念
可用性、可伸缩性和群集技术
Windows Server(R) 2008 提供两 种群集技术 ：故障转移 群集 （ Cluster ）和网络 负载平衡 (NLB)。故障转移群集主要提供高可用性；网络负载平衡提供可伸缩性，并同时帮助提高基 于 Web 服务的可用性。 群集技术（故障转移群集或网络负载平衡）的选择主要取决于所运行的应用程序 • 故障转移群集是针对具有长期运行的内存中状态或具有大型的、频繁更新的数据状
SQL Server 2008 故障转移群集部署教程
编 修 审 批
制：李 亮 正： 核： 准：
日 日日 日
期：2010 年 12 月 09 日 期： 期： 期：
一、 故障转移群集的概念············································································································· - 1 二、 资源规划和软硬件环境 ········································································································· - 2 三、 部署步骤大纲··························································································································- 3 四、 Windows 操作系统 ················································································································· - 3 1. 安装三台服务器的操作系统：··························································································- 3 2. 配置系统······························································································································· - 3 3. 启用远程配置·······················································································································- 4 五、 Windows 域环境······················································································································- 4 1. 安装域控制器；···················································································································- 4 2. 创建 windows 群集账户 ······································································································- 4 3. 创建 SQL server 群集账户、组························································································· - 4 4. 授权群集账户（组)············································································································· - 5 六、 共享存储设备的配置············································································································· - 6 1. 共享存储设备的类型·········································································································· - 6 2. 共享总线的共享存储设备··································································································- 6 3. iSCSI 共享存储设备·············································································································- 8 七、 网络和磁盘配置······················································································································- 9 1. 网络配置······························································································································· - 9 2. 磁盘配置····························································································································· - 12 八、 安装 windows 故障转移群集······························································································ - 14 1. 添加故障转移功能············································································································ - 14 2. MSCS 验证配置··················································································································- 16 3. 创建 MSCS 故障转移群集······························································································· - 25 4. 配置群集····························································································································· - 29 5. 验证 windows 群集的故障转移功能···············································································- 32 九、 安装 SQL server2008 故障转移群集：··············································································- 35 1. 添加分布式事务处理的集群化························································································- 35 2. 部署必要的安装环境········································································································ - 38 3. 安装 SQL server 2008 故障转移群集··············································································- 38 4. 配置 SQL Server 2008 故障转移群集············································································· - 57 5. 验证 SQL Server 2008 故障转移功能············································································· - 57 十、 总结·········································································································································- 60 -
态的应用程序而设计。这些应用程序称为状态应用程序，并且它们包括数据库应用程序 和消息应用程序。故障转移群集的典型使用包括文件服务器、打印服务器、数据库服务 器和消息服务器。 • 网络负载平衡适用于没有长期运行的内存中状态的应用程序。这些应用程序称为无