iT邦幫忙

2019 iT 邦幫忙鐵人賽

DAY 26
1
自我挑戰組

IT系統建置系列 第 26

IT系統建置--系統面建置(26)-SQL Server容錯移轉叢集建置

  • 分享至 

  • xImage
  •  
  • 容錯移轉功能主要是可預防SQL主機硬體及系統、應用程式意外性的發生,避免企業資訊服務的中斷。

  • 環境架構 :
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771fbb4ENqCv8.jpg

https://ithelp.ithome.com.tw/upload/images/20181108/20110771dDCNVIJiix.jpg

  1. SQLSRV01及SQLSRV02安裝容錯移轉叢集功能
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771BThOibMv95.jpg

  2. 開啟容錯移轉叢集管理員,開始建立叢集服務
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771LOoEMVWfak.jpg

  3. 選擇2台SQL主機
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771u4Xcjj33JF.jpg

  4. 輸入管理叢集名稱及IP位址
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771fK8zhlecDy.jpg

  5. 等待建立叢集中
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771UuTt8MIQOD.jpg

  6. 好像出現一些警告訊息
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771pEIJB7pA6q.jpg

  7. 看來要好好研究一下了… (我先將SQLSRV02節點收回)
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771mHtzk6tRG5.jpg

  8. 新增磁碟並將3個掛載share storage的磁碟加進去
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771HDjBq2GKiD.jpg

  9. 檢查3個磁碟狀況
    https://ithelp.ithome.com.tw/upload/images/20181108/20110771S7ivmUGlvn.jpg

10.接著設定DTC
https://ithelp.ithome.com.tw/upload/images/20181108/201107710zHOpx97ac.jpg

11.選擇DTC服務
https://ithelp.ithome.com.tw/upload/images/20181108/20110771TTWaaucyB7.jpg

12.輸入DTC服務名稱及IP位址
https://ithelp.ithome.com.tw/upload/images/20181108/201107715MGvm7QdQU.jpg

13.選擇存放DTC的磁碟
https://ithelp.ithome.com.tw/upload/images/20181108/20110771yhuAKef0h5.jpg

14.DTC建立完成
https://ithelp.ithome.com.tw/upload/images/20181108/20110771vqriui1oh5.jpg

15.測試一下DTC是否可以正常轉移至SQLSRV02主機
https://ithelp.ithome.com.tw/upload/images/20181108/20110771ipUqBado1q.jpg

16.測試可成功移轉至SQLSRV02
https://ithelp.ithome.com.tw/upload/images/20181108/20110771PLP2PyIC8S.jpg

17.接著仲裁設定
https://ithelp.ithome.com.tw/upload/images/20181108/20110771RLBGA3XDPc.jpg

18.下一步
https://ithelp.ithome.com.tw/upload/images/20181108/20110771dpEnG6iMyV.jpg

19.選擇叢集群組磁碟
https://ithelp.ithome.com.tw/upload/images/20181108/20110771t2hgpcmk83.jpg

20.仲裁磁碟建立完成
https://ithelp.ithome.com.tw/upload/images/20181108/20110771JpMpvunBZG.jpg

21.於SQLSRV01安裝SQL容錯移轉叢集
https://ithelp.ithome.com.tw/upload/images/20181108/20110771Mlfis5qZrT.jpg

22.出現錯誤訊息了....
https://ithelp.ithome.com.tw/upload/images/20181108/20110771tvQuTDtp3m.jpg

23.只要跑一次驗證叢集驗證成功即可
https://ithelp.ithome.com.tw/upload/images/20181108/20110771XFMn8q56Xz.jpg

24.可正常安裝SQL容錯轉移叢集
https://ithelp.ithome.com.tw/upload/images/20181108/20110771moyMHwWSMb.jpg

25.設定SQL Server叢集的網路名稱
https://ithelp.ithome.com.tw/upload/images/20181108/20110771S51xUvTUmV.jpg

26.設定容錯移轉叢集節點IP位址(172.16.0.68)
https://ithelp.ithome.com.tw/upload/images/20181108/20110771ibWPmWv4dl.jpg

27.陸續設定直到安裝完成即可
https://ithelp.ithome.com.tw/upload/images/20181108/20110771kDeYNDuOQ0.jpg

28.至Cluster管理員可以看到剛剛安裝容錯移轉的服務
https://ithelp.ithome.com.tw/upload/images/20181108/20110771R0pyLgKSBa.jpg

29.接著至SQLSRV02主機將節點加入至SQL容錯移轉叢集
https://ithelp.ithome.com.tw/upload/images/20181108/20110771nbyYPj9j5n.jpg

30.輸入叢集SQL名稱
https://ithelp.ithome.com.tw/upload/images/20181108/20110771u9kZQZ9gaZ.jpg

31.下一步
https://ithelp.ithome.com.tw/upload/images/20181108/201107718dIL2icIuh.jpg

32.完成
https://ithelp.ithome.com.tw/upload/images/20181108/20110771WFBdWG3RwS.jpg

33.目前SQLSRV01主機為主要運作的伺服器
https://ithelp.ithome.com.tw/upload/images/20181108/20110771Spwsz4pRUJ.jpg

34.測試將SQLSRV01主機關機
https://ithelp.ithome.com.tw/upload/images/20181108/20110771hLmdOsWEON.jpg

35.SQL服務已移轉至SQLSRV02主機並持續運作中
https://ithelp.ithome.com.tw/upload/images/20181108/20110771nOFG9VDoAZ.jpg

36.這邊可以看到仲裁、DTC、SQL_Data磁碟皆已移轉至SQLSRV02主機
https://ithelp.ithome.com.tw/upload/images/20181108/201107711ClkftIRgs.jpg

下一篇兩個網域之間信任建置


上一篇
IT系統建置--系統面建置(25)-Windows server IIS網頁+NLB網路負載平衡建置
下一篇
IT系統建置--系統面建置(27)-兩個網域信任建置
系列文
IT系統建置30
圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

立即登入留言