SQL Server2000 群集服務(wù)配置

1、sql server 群集服務(wù)配置1、 需求許多企業(yè)采用了sql server提供業(yè)務(wù)系統(tǒng)后臺數(shù)據(jù)服務(wù)，隨著企業(yè)運(yùn)作對這些業(yè)務(wù)系統(tǒng)的依賴，如何提高這些系統(tǒng)的高可靠性、高可用性已越來越引起企業(yè)的關(guān)注。為滿足企業(yè)系統(tǒng)高可用性容錯業(yè)務(wù)需求，微軟強(qiáng)力推薦用戶采用windows server 2003企業(yè)版、sql server 2000企業(yè)版來構(gòu)建其業(yè)務(wù)應(yīng)用與協(xié)作辦公平臺。由于windows server 2003、sql server 2000中內(nèi)置cluster群集功能，外加一共享磁盤柜或san，2臺服務(wù)器就能實(shí)現(xiàn)群集配置，sql server 2000（節(jié)點(diǎn)服務(wù)器1）互為熱備地對外提供服務(wù)，即充

2、分利用了服務(wù)器硬件資源，又大大提高了整個(gè)業(yè)務(wù)應(yīng)用與協(xié)作辦公系統(tǒng)的高可用性，如右圖所示：2、 方案由于微軟的cluster群集配置必須要有域環(huán)境支持，依據(jù)域控制器是否有獨(dú)立的物理服務(wù)器來承擔(dān)，配置方案可分為兩大類，暫且稱為標(biāo)準(zhǔn)配置與精簡配置，具體情況如下。方案一：標(biāo)準(zhǔn)配置此配置中，2臺域控制器獨(dú)立，承擔(dān)ad域用戶驗(yàn)證、dns服務(wù)等功能。方案二：精簡配置某些情況下，用戶的環(huán)境無域存在，且僅有此2臺服務(wù)器，此時(shí)可嘗試將2臺群集服務(wù)器兼作ad域控制器與dns服務(wù)器。此混裝精簡配置方式會降低系統(tǒng)的可靠性與可用性，微軟強(qiáng)烈建議采用獨(dú)立的域控制器。3、 步驟下面以精簡配置方案為例，來解說系統(tǒng)的安裝配置并驗(yàn)證

3、其可行性。3.1 windows server 2003群集安裝配置有關(guān)windows server 2003群集系統(tǒng)的安裝配置詳細(xì)事項(xiàng)，請參考/longrujun/archive/2005/01/08/244617.aspx3.2安裝 microsoft 分布式事務(wù)協(xié)調(diào)器在運(yùn)行 windows server 2003的服務(wù)器上安裝 sqlserver2000 之前，必須首先在群集上安裝 microsoft 分布式事務(wù)協(xié)調(diào)器 (msdtc)。1. 登錄到群集中的任意節(jié)點(diǎn)，如nodea；2. 單擊“開始”，指向“所有程序”，再指向“管理工具”，然后單擊“群集

4、管理器”；3. 在“群集組”下，以鼠標(biāo)右鍵單擊“群集組”，指向“新建”，再單擊“資源”；4. 在“新建資源”的“名稱”框中，鍵入名稱，如“msdtc”；在“資源類型”列表中，選擇“分布式事務(wù)協(xié)調(diào)器（dtc）”，在“組”列表中，確保選中了“群集組”，next,5. 驗(yàn)證所有節(jié)點(diǎn)（nodea,nodeb）都已出現(xiàn)在“可能的所有者”列表中，next,6. 選擇仲裁磁盤“qdisk:q”和“cluster name”資源作為依存資源，ok7, ok,以鼠標(biāo)右鍵單擊“cluster group”，再單擊“bring online”，使得分布式事務(wù)協(xié)調(diào)器資源“msdtc”聯(lián)機(jī)在線。3.2 sql serv

5、er 2000群集安裝配置sql server 2000的群集安裝已直接集成到sql server 2000的數(shù)據(jù)庫安裝向?qū)е校軌蜃詣幼R別到windows server 2003上的群集系統(tǒng)并啟用數(shù)據(jù)庫虛擬服務(wù)器選項(xiàng)，實(shí)現(xiàn)sql server 2000群集虛擬服務(wù)器在2臺服務(wù)器上的自動安裝配置。記住，安裝完成后，須安裝sql2000 sp3補(bǔ)丁包。下面以屏幕截圖的方式來看看其簡單自動的安裝配置過程。為確保sql server 2000群集在2臺服務(wù)器上的自動安裝配置，2臺服務(wù)器nodea與nodeb,以及共享磁盤柜都須處于開機(jī)在線狀態(tài)。a、安裝sql server 2000在節(jié)點(diǎn)服務(wù)器nod

6、ea上安裝sql2000_ent，放入sql server 2000企業(yè)版安裝光盤，啟動sql server 2000的安裝向?qū)?；安裝向?qū)нM(jìn)入到“計(jì)算機(jī)名”界面時(shí)，自動識別到windows server 2003的群集系統(tǒng)，啟用了“虛擬服務(wù)器”選項(xiàng)，選擇該選項(xiàng)，輸入虛擬sql server名稱virsqlcluster， next,用戶信息界面,next,用戶許可證協(xié)議界面單擊”是”,“故障轉(zhuǎn)移群集”界面，輸入ip地址“00”，選用網(wǎng)絡(luò)“public”，單擊“添加”，使其添加到列表中，如圖next,“群集磁盤選擇”界面，選擇“group 0”的“disk s：”，next,

7、“群集管理”界面，確保nodea與nodeb都在“已配置節(jié)點(diǎn)”列表中，如圖next,遠(yuǎn)程信息”界面，輸入用戶名，密碼與域名，如圖next,實(shí)例名”界面，選擇“默認(rèn)”，如圖next,“安裝類型”界面，選擇“典型”，由于前面磁盤選擇了“group 0”的“disk s：”，“目的文件夾”的“數(shù)據(jù)文件”自動定位到s:盤，而sql程序文件則會自動安裝到1 與2的本地盤相關(guān)目錄下，如圖next,“服務(wù)帳戶”界面，選擇“對每個(gè)服務(wù)使用同一帳戶”，由于是群集配置，“使用本地系統(tǒng)帳戶”選項(xiàng)自動失效，輸入用戶名、密碼與域名，next,.next,“選擇許可模式”界面，選擇“處理器許可證”，如圖，next,安裝向

8、導(dǎo)進(jìn)入自動安裝配置過程，等待直至出現(xiàn)“安裝完畢”界面 ok,安裝已經(jīng)完成了打開“群集管理器”，可看到“資源類型”中多了兩個(gè)sql server的資源，這是因?yàn)閟ql server 2000企業(yè)版為cluster-aware的應(yīng)用系統(tǒng)，安裝配置時(shí)自動添加了支持cluster的服務(wù)組件；“group 0”，可看到除原有的“disk s:”外，新添了5個(gè)sql資源，而且都已聯(lián)機(jī)，說明sql server 2000群集安裝配置完成；測試一下結(jié)果如圖b、安裝sql server 2000 sp3補(bǔ)丁包啟動sql server 2000 service pack 3安裝程序，“歡迎”界面，next, “計(jì)

9、算機(jī)名”界面，輸入群集虛擬服務(wù)器名virsqlcluster，單擊next, “連接到服務(wù)器”界面，選擇“windows身份驗(yàn)證”， next,“后向兼容性一覽表”界面，選擇“升級microsoft search并應(yīng)用sql server 2000 sp3（必需）”，next, “錯誤報(bào)告”界面，next, “遠(yuǎn)程信息”界面，輸入用戶名、密碼與域名，next,安裝向?qū)г谌杭?jié)點(diǎn)（nodea與nodeb）上執(zhí)行所需操作，等待即可；安裝等待過程中切換到“群集管理器”，可看到sql的幾個(gè)cluster-aware服務(wù)處于脫機(jī)狀態(tài)；sp3安裝完成后，會顯示下面的信息框，單擊確定； “安裝完畢”界面，選

10、擇“是的，我想現(xiàn)在重新啟動計(jì)算機(jī)”，單擊完成，節(jié)點(diǎn)服務(wù)器nodea重新啟動；nodea啟動完成后，重啟節(jié)點(diǎn)服務(wù)器nodeb至此，sql server 2000群集安裝配置完成。有關(guān)sql server 2000群集系統(tǒng)的安裝配置詳細(xì)事項(xiàng)，請參閱/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/failclus.aspsystem configuration: sun microsystems i86pcmemory size: 1024 megabyt

11、essystem peripherals (prom nodes):node 0x000001 bios-boot-device: 80 stdout: 00000000 name: i86pc node 0x000002 existing: 01034000.00000000.078b4001.00000000 name: ramdisk node 0x000003 bus-type: isa device_type: isa name: isa node 0x000004 device_type: pci reg: 00000000.00000000.00000000 #size-cell

12、s: 00000002 #address-cells: 00000003 name: pci node 0x000005 assigned-addresses: c2000010.00000000.f8000000.00000000.02000000 reg: 00000000.00000000.00000000.00000000.00000000.42000010.00000000.00000000.00000000.02000000 compatible: pci10de,e1.a1 + pci10de,e1 + pciclass,060000 + pciclass,0600 model:

13、 host bridge power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 max-latency: 00000000 min-grant: 00000000 unit-address: 0 class-code: 00060000 revision-id: 000000a1 vendor-id: 000010de device-id: 000000e1 name: pci10de,e1 node 0x000006 reg: 00000800.0000000

14、0.00000000.00000000.00000000 compatible: pci10de,e0.1458.c11.a2 + pci10de,e0.1458.c11 + pci1458,c11 + pci10de,e0.a2 + pci10de,e0 + pciclass,060100 + pciclass,0601 model: isa bridge power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 max-latency: 00000000 min

15、-grant: 00000000 subsystem-vendor-id: 00001458 subsystem-id: 00000c11 unit-address: 1 class-code: 00060100 revision-id: 000000a2 vendor-id: 000010de device-id: 000000e0 name: pci1458,c11 node 0x000007 assigned-addresses: 81000910.00000000.0000e400.00000000.00000020.81000920.00000000.00001c00.0000000

16、0.00000040.81000924.00000000.00002000.00000000.00000040 reg: 00000900.00000000.00000000.00000000.00000000.01000910.00000000.00000000.00000000.00000020.01000920.00000000.00000000.00000000.00000040.01000924.00000000.00000000.00000000.00000040 compatible: pci10de,e4.1458.c11.a1 + pci10de,e4.1458.c11 +

17、pci1458,c11 + pci10de,e4.a1 + pci10de,e4 + pciclass,0c0500 + pciclass,0c05 model: smbus (system management bus) power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts: 00000001 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 s

18、ubsystem-id: 00000c11 unit-address: 1,1 class-code: 000c0500 revision-id: 000000a1 vendor-id: 000010de device-id: 000000e4 name: pci1458,c11 node 0x000008 assigned-addresses: 82001010.00000000.fc004000.00000000.00001000 reg: 00001000.00000000.00000000.00000000.00000000.02001010.00000000.00000000.000

19、00000.00001000 compatible: pci10de,e7.1458.5004.a1 + pci10de,e7.1458.5004 + pci1458,5004 + pci10de,e7.a1 + pci10de,e7 + pciclass,0c0310 + pciclass,0c03 model: universal serial bus ohci compliant power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts:

20、 00000001 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 subsystem-id: 00005004 unit-address: 2 class-code: 000c0310 revision-id: 000000a1 vendor-id: 000010de device-id: 000000e7 name: pci1458,5004 node 0x000009 assigned-addresses: 82001110.00000000.fc005000.00000000.0000100

21、0 reg: 00001100.00000000.00000000.00000000.00000000.02001110.00000000.00000000.00000000.00001000 compatible: pci10de,e7.1458.5004.a1 + pci10de,e7.1458.5004 + pci1458,5004 + pci10de,e7.a1 + pci10de,e7 + pciclass,0c0310 + pciclass,0c03 model: universal serial bus ohci compliant power-consumption: 0000

22、0001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts: 00000002 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 subsystem-id: 00005004 unit-address: 2,1 class-code: 000c0310 revision-id: 000000a1 vendor-id: 000010de device-id: 000000e7 name: pci145

23、8,5004 node 0x00000a assigned-addresses: 82001210.00000000.fc000000.00000000.00000100 reg: 00001200.00000000.00000000.00000000.00000000.02001210.00000000.00000000.00000000.00000100 compatible: pci10de,e8.1458.5004.a2 + pci10de,e8.1458.5004 + pci1458,5004 + pci10de,e8.a2 + pci10de,e8 + pciclass,0c032

24、0 + pciclass,0c03 model: universal serial bus ehci compliant power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts: 00000003 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 subsystem-id: 00005004 unit-address: 2,2 class-code:

25、 000c0320 revision-id: 000000a2 vendor-id: 000010de device-id: 000000e8 name: pci1458,5004 node 0x00000b assigned-addresses: 82002810.00000000.fc001000.00000000.00001000.81002814.00000000.0000b800.00000000.00000008 reg: 00002800.00000000.00000000.00000000.00000000.02002810.00000000.00000000.00000000

26、.00001000.01002814.00000000.00000000.00000000.00000008 compatible: pci10de,df.1458.e000.a2 + pci10de,df.1458.e000 + pci1458,e000 + pci10de,df.a2 + pci10de,df + pciclass,068000 + pciclass,0680 model: bridge device power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00

27、000000 interrupts: 00000001 max-latency: 00000014 min-grant: 00000001 subsystem-vendor-id: 00001458 subsystem-id: 0000e000 unit-address: 5 class-code: 00068000 revision-id: 000000a2 vendor-id: 000010de device-id: 000000df name: pci1458,e000 node 0x00000c assigned-addresses: 81003010.00000000.0000bc0

28、0.00000000.00000100.81003014.00000000.0000c000.00000000.00000080.82003018.00000000.fc002000.00000000.00001000 reg: 00003000.00000000.00000000.00000000.00000000.01003010.00000000.00000000.00000000.00000100.01003014.00000000.00000000.00000000.00000080.02003018.00000000.00000000.00000000.00001000 compa

29、tible: pci10de,ea.1458.a002.a1 + pci10de,ea.1458.a002 + pci1458,a002 + pci10de,ea.a1 + pci10de,ea + pciclass,040100 + pciclass,0401 model: audio device power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts: 00000001 max-latency: 00000005 min-grant:

30、00000002 subsystem-vendor-id: 00001458 subsystem-id: 0000a002 unit-address: 6 class-code: 00040100 revision-id: 000000a1 vendor-id: 000010de device-id: 000000ea name: pci1458,a002 node 0x00000d #size-cells: 00000000 #address-cells: 00000001 device_type: pci-ide assigned-addresses: 81004010.00000000.

31、000001f0.00000000.00000008.81004014.00000000.000003f6.00000000.00000001.81004018.00000000.00000170.00000000.00000008.8100401c.00000000.00000376.00000000.00000001.81004020.00000000.0000f000.00000000.00000010 reg: 00004000.00000000.00000000.00000000.00000000.81004010.00000000.000001f0.00000000.0000000

32、8.81004014.00000000.000003f6.00000000.00000001.81004018.00000000.00000170.00000000.00000008.8100401c.00000000.00000376.00000000.00000001.01004020.00000000.00000000.00000000.00000010 compatible: pci10de,e5.1458.5002.a2 + pci10de,e5.1458.5002 + pci1458,5002 + pci10de,e5.a2 + pci10de,e5 + pciclass,0101

33、8a + pciclass,0101 model: ide controller power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 subsystem-id: 00005002 unit-address: 8 class-code: 0001018a revision-id: 000000a2 vendor-id:

34、000010de device-id: 000000e5 name: pci-ide node 0x00000e reg: 00000000 name: ide node 0x00000f reg: 00000001 name: ide node 0x000010 #size-cells: 00000000 #address-cells: 00000001 device_type: pci-ide assigned-addresses: 81005010.00000000.000009f0.00000000.00000008.81005014.00000000.00000bf2.0000000

35、0.00000001.81005018.00000000.00000970.00000000.00000008.8100501c.00000000.00000b72.00000000.00000001.81005020.00000000.0000dc00.00000000.00000010.81005024.00000000.0000e000.00000000.00000080 reg: 00005000.00000000.00000000.00000000.00000000.01005010.00000000.00000000.00000000.00000008.01005014.00000

36、000.00000000.00000000.00000001.01005018.00000000.00000000.00000000.00000008.0100501c.00000000.00000000.00000000.00000001.01005020.00000000.00000000.00000000.00000010.01005024.00000000.00000000.00000000.00000080 compatible: pci10de,e3.1458.b002.a2 + pci10de,e3.1458.b002 + pci1458,b002 + pci10de,e3.a2

37、 + pci10de,e3 + pciclass,010185 + pciclass,0101 model: ide controller power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000000 interrupts: 00000001 max-latency: 00000001 min-grant: 00000003 subsystem-vendor-id: 00001458 subsystem-id: 0000b002 unit-address: a clas

38、s-code: 00010185 revision-id: 000000a2 vendor-id: 000010de device-id: 000000e3 name: pci-ide node 0x000011 reg: 00000000 name: ide node 0x000012 reg: 00000001 name: ide node 0x000013 reg: 00005800.00000000.00000000.00000000.00000000 compatible: pci10de,e2.a2 + pci10de,e2 + pciclass,060400 + pciclass

39、,0604 model: pci-pci bridge ranges: 81000000.00000000.0000a000.81000000.00000000.0000a000.00000000.00001000.82000000.00000000.fa000000.82000000.00000000.fa000000.00000000.02000000.c2000000.00000000.e8000000.c2000000.00000000.e8000000.00000000.10000000 bus-range: 00000001.00000001 #size-cells: 000000

40、02 #address-cells: 00000003 device_type: pci power-consumption: 00000001.00000001 66mhz-capable: devsel-speed: 00000001 unit-address: b class-code: 00060400 revision-id: 000000a2 vendor-id: 000010de device-id: 000000e2 name: pci10de,e2 node 0x000019 display-edif-id: sam1058 video-adapter-type: svga

41、display-type: color display-edif-block: ffffff00.00ffffff.10582d4c.50313335.01010a21.7e182068.a56912e8.24994952.ff4c480e.593100fe.59615945.01018081.01010101.15f90101.5830f820.4020201f.e6320013.1e000010.600024ea.30280041.00136030.0010e632.00001e00.3200fd00.0b461ea0.20200a00.20202020.ff000000.41564800

42、.3031384e.0a323633.bf002020 assigned-addresses: c2010010.00000000.e8000000.00000000.08000000.81010014.00000000.0000a000.00000000.00000100.82010018.00000000.fb000000.00000000.00010000.a1010000.00000000.000003b0.00000000.0000000c.a1010000.00000000.000003c0.00000000.00000020.82010000.00000000.000a0000.

43、00000000.00020000 reg: 00010000.00000000.00000000.00000000.00000000.42010010.00000000.00000000.00000000.08000000.01010014.00000000.00000000.00000000.00000100.02010018.00000000.00000000.00000000.00010000.a1010000.00000000.000003b0.00000000.0000000c.a1010000.00000000.000003c0.00000000.00000020.8201000

44、0.00000000.000a0000.00000000.00020000 compatible: pci1002,5961.1787.2002.1 + pci1002,5961.1787.2002 + pci1787,2002 + pci1002,5961.1 + pci1002,5961 + pciclass,030000 + pciclass,0300 model: vga compatible controller power-consumption: 00000001.00000001 66mhz-capable: fast-back-to-back: devsel-speed: 00000001 interrupts: 00000001 max-latency: 00000000 min-grant: 00000008 subsystem-vendor-id: 00001787 subsystem-id: 00002002 device_type: display unit-address: 0 class-code: 00030000 revision-id: 00000001 vendor-id: 00001002 device-id: 00005961 name: disp