sqlserver集群配置(三)

2015-07-24 06:31:16 · 作者: · 浏览: 15
/1_sf5v9__.gif" \* MERGEFORMATINET

?

9 完成

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_tm4ff__.gif" \* MERGEFORMATINET

?

10 群集 win2003cluster 已经配置成功。但是目前只有win1,我们需要将第二个节点加入,构建出容灾群集。

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_9jmua__.gif" \* MERGEFORMATINET

?

?

?

11 新建节点

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_ehcza__.gif" \* MERGEFORMATINET

?

12 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_uwwuf__.gif" \* MERGEFORMATINET

?

?

?

?

13 输入“win2”

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_vsync__.png" \* MERGEFORMATINET

?

14 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_pwj5a__.gif" \* MERGEFORMATINET

?

?

15 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_vdtgn__.gif" \* MERGEFORMATINET

?

16 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_hteoo__.gif" \* MERGEFORMATINET

?

?

?

17 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_aguq3__.gif" \* MERGEFORMATINET

Win2上的共享磁盘QDisk 和ClusterData 已经被win1 所独占。这个警告不用理会

?

?

18 下一步,完成win2节点添加

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_uc7l1__.gif" \* MERGEFORMATINET

?

?

19 操作系统容灾群集已经安装完毕。

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_l1sxg__.gif" \* MERGEFORMATINET

?

?

20 配置群集网络通信 右键选择群集“属性”

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_wgjom__.gif" \* MERGEFORMATINET

?

21 本地连接2 -à属性

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_p31nu__.png" \* MERGEFORMATINET

?

?

22 专门用于群集节点内部通讯使用的

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_fi83s__.png" \* MERGEFORMATINET

?

?

23确保private 在public 上面(private 优先级更高)。确定完成网络设置。

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_qqaz3__.jpg" \* MERGEFORMATINET

?

?

?

24 测试操作系统群集

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_jap90__.gif" \* MERGEFORMATINET

?

?

25 点击移动组可以相互切换资源

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_uao6j__.png" \* MERGEFORMATINET

?

?

?

?

26为了测试群集的可用性,在win1 上右键选择“停止群集服务”

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_grq3t__.png" \* MERGEFORMATINET

?

27 Win2 接管了资源,成为目前群集的工作节点

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_2i9xp__.png" \* MERGEFORMATINET

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_tphzb__.png" \* MERGEFORMATINET

?

28 重新启动win1

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_mbprk__.jpg" \* MERGEFORMATINET

Windowns server2003集群完成配置

?

五 :配置SQL Server 2005 群集

1说明:如果群集环境不需要安装报表服务(SQL Server Reporting Services),可以忽略此步骤。

安装IIS

?

2 打开组件服务---计算机---我的电脑---属性—安全配置,选择administrator 用户登陆,输入administrator

的密码。

这一步是必须的,否则在安装SQL server 2005 的时候会出现COM+错误。

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_vm4wv__.gif" \* MERGEFORMATINET

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_hydn4__.gif" \* MERGEFORMATINET

?

?

3 配置MSDTC 到资源组中

进入 CMD 运行

net stop msdtc

msdtc –uninstall

msdtc –install

net start msdtc

?

此操作之后在群集组直接出现 MSDTC 资源

如果出现msdtc无法正常使用