º» ¹®¼¿¡¼´Â Microsoft Cluster Server¿¡ Microsoft SQL Server 2000 Enterprise EditionÀ» ¼³Ä¡Çϱâ À§ÇÑ ÀϹÝÀûÀÎ ¿ä±¸ »çÇ× ¹× ´Ü°è¸¦ ¼³¸íÇÕ´Ï´Ù.
Âü°í:
Microsoft SQL Server 2000 Books OnlineÀÇ "failover clustering" »öÀÎ Ç׸ñ¿¡ º» ¹®¼ÀÇ ³»¿ë°ú Ãß°¡ÀûÀÎ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. »ç¿ëÀÚÀÇ ÆíÀǸ¦ À§ÇØ ±× Á¤º¸¸¦ ÀÌ Microsoft ±â¼ú ÀÚ·á ¹®¼¿¡ ³Ö¾ú½À´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ ´ëÇÑ Àǹ® »çÇ×ÀÌ ÀÖÀ¸¸é ¸ÕÀú SQL Server 2000 Books OnlineÀ» ÂüÁ¶ÇϽʽÿÀ.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)
Microsoft¢ç SQL Server¢â 2000 Enterprise Edition¿¡¼ SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)Àº ³ôÀº °¡¿ë¼º Áö¿øÀ» Á¦°øÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ¿î¿µ üÁ¦¿¡ ¿À·ù°¡ ¹ß»ýÇϰųª °èȹµÈ ¾÷±×·¹À̵带 ¼öÇàÇÒ ¶§ ÇÑ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼º¿¡ Æ÷ÇÔµÈ ´Ù¸¥ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)µÇµµ·Ï ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ¹æ¹ýÀ¸·Î ½Ã½ºÅÛ Áß´Ü ½Ã°£À» ÃÖ¼ÒÈÇÏ¿© ¼¹öÀÇ °¡¿ë¼ºÀ» ³ôÀÏ ¼ö ÀÖ½À´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡Çϱâ Àü¿¡
Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡Çϱâ Àü¿¡ ÄÄÇ»ÅÍ¿¡¼ ½ÇÇàÇÒ ¿î¿µ üÁ¦¸¦ ¼±ÅÃÇØ¾ß ÇÕ´Ï´Ù. Microsoft Windows NT 4.0 Enterprise Edition, Microsoft Windows 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. Microsoft Cluster Service(MSCS)µµ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.
Âü°í: ¼÷·ÃµÈ »ç¿ëÀÚÀÎ °æ¿ì SQL Server 2000 Ŭ·¯½ºÅÍ ¼³Ä¡ ´Ü°è¸¦ ±¸Ã¼ÀûÀ¸·Î ¾Ë·Á¸é º» ¹®¼ÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â: ½ÇÁ¦ ¼³Ä¡" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ.
°æ°í: Microsoft´Â ¸ðµç »ç¿ëÀÚ°¡ º» ¹®¼¸¦ ÀÖ´Â ±×´ë·Î »ç¿ëÇÒ °ÍÀ» ±ÇÀåÇÕ´Ï´Ù.
¼³Ä¡ Àü °Ë»ç ¸ñ·Ï
¼³Ä¡¸¦ ½ÃÀÛÇϱâ Àü¿¡ ¾Æ·¡¿Í °°Àº »çÇ×À» È®ÀÎÇÕ´Ï´Ù.
-
³×Æ®¿öÅ© ÀÎÅÍÆäÀ̽º Ä«µå(NIC)¿Í µå¶óÀ̺ê/¹è¿(SCSI) ÄÁÆ®·Ñ·¯°¡ IRQ¸¦ °øÀ¯ÇÏÁö ¾Ê¾Æ¾ß ÇÕ´Ï´Ù. ÀϺΠÇϵå¿þ¾î´Â ÀÌ·¯ÇÑ IRQ °øÀ¯¸¦ Áö¿øÇÏÁö¸¸ °øÀ¯ÇÏÁö ¾Ê´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
-
»ç¿ë ÁßÀÎ Çϵå¿þ¾î°¡ Microsoft Windows NT Çϵå¿þ¾î ȣȯ ¸ñ·Ï¿¡ Æ÷ÇԵǾî ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Áö¿øµÇ´Â Çϵå¿þ¾îÀÇ Àüü ¸ñ·ÏÀ» º¸·Á¸é ¾Æ·¡ À¥ »çÀÌÆ®¿¡¼ Çϵå¿þ¾î ȣȯ ¸ñ·Ï(HCL)À» ÂüÁ¶ÇϽʽÿÀ.
Çϵå¿þ¾î ½Ã½ºÅÛÀÌ HCLÀÇ Cluster ¹üÁÖ¿¡ ³ª¿Í ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Ŭ·¯½ºÅÍ¿¡ »ç¿ëÀÚ°¡ Ãß°¡ÇÑ °³º° Ŭ·¯½ºÅÍ ±¸¼º ¿ä¼Ò´Â ½ÂÀÎµÈ ½Ã½ºÅÛ¿¡ ¼ÓÇÏÁö ¾Ê½À´Ï´Ù. Cluster ¹üÁÖ¿¡ ³ª¿Í ÀÖ°í Ŭ·¯½ºÅÍ ¼Ö·ç¼ÇÀ¸·Î ±¸ÀÔÇÑ ½Ã½ºÅÛ¸¸ÀÌ ½ÂÀÎµÈ Çϵå¿þ¾îÀÔ´Ï´Ù. ¸ñ·ÏÀ» È®ÀÎÇÒ ¶§ °Ë»ö ¹üÁÖ·Î Cluster¸¦ ¼±ÅÃÇϽʽÿÀ. ´Ù¸¥ ¹üÁÖ´Â ¸ðµÎ OEM¿ëÀÔ´Ï´Ù.
-
¸ðµç ³ëµå¿¡¼ µ¿½Ã¿¡ Microsoft Windows NT 4.0 Enterprise Edition, Microsoft Windows 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¸¦ ½ÇÇàÇϱâ Àü¿¡ Àû¾îµµ ÇÑ ³ëµå¿¡¼ MSCS°¡ ¿ÏÀüÈ÷ ¼³Ä¡µÇ¾ú´ÂÁö È®ÀÎÇÕ´Ï´Ù. MSCS¸¦ »ç¿ëÇÒ ¶§ ´Ù¸¥ ³ëµå¸¦ ¿Â¶óÀο¡ ¿¬°áÇϱâ Àü¿¡ ÇÑ ³ëµå¿¡¼ ³ëµå°¡ °øÀ¯ SCSI ¹ö½ºÀÇ Á¦¾î¸¦ ¹Þ°í ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. ÇÑ ³ëµå°¡ °øÀ¯ SCSI ¹ö½ºÀÇ Á¦¾î¸¦ ¹ÞÁö ¾ÊÀ¸¸é ÀÀ¿ë ÇÁ·Î±×·¥ Àå¾Ö Á¶Ä¡(Failover)·Î ÀÎÇØ ¿Â¶óÀÎ º¸·ù »óŰ¡ µÉ ¼ö ÀÖ½À´Ï´Ù. ±× °á°ú ´Ù¸¥ ³ëµå¿¡¼ Ŭ·¯½ºÅͰ¡ ½ÇÆÐÇϰųª Àüü ³ëµå°¡ ½ÇÆÐÇÕ´Ï´Ù. ±×·¯³ª, Çϵå¿þ¾î Á¦Á¶¾÷ü°¡ µ¶Á¡ÀûÀÎ ¼³Ä¡ ¹æ¹ýÀ» Á¦°øÇÏ´Â °æ¿ì¿¡´Â Çϵå¿þ¾î Á¦Á¶¾÷üÀÇ ÁöħÀ» µû¶ó¾ß ÇÕ´Ï´Ù.
-
Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¿¡¼ ¼³¸íÇÏ´Â ´ë·Î Windows Internet Name Service(WINS)¸¦ ¼³Ä¡Çß´ÂÁö È®ÀÎÇÕ´Ï´Ù.
258750
(http://support.microsoft.com/kb/258750/KO/
)
Ŭ·¯½ºÅÍ ¼¹ö¿¡ ±ÇÀåÇÏ´Â °³ÀÎ "ÇÏÆ®ºñÆ®" ±¸¼º
-
Ŭ·¯½ºÅ͸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â µð½ºÅ©ÀÇ µå¶óÀÌºê ¹®ÀÚ°¡ µÎ ¼¹ö¿¡¼ µ¿ÀÏÇÑÁö È®ÀÎÇÕ´Ï´Ù.
-
SQL Server ¼³Ä¡ ÇÁ·Î±×·¥À» ½ÃÀÛÇϱâ Àü¿¡ ¸ðµç °³ÀÎ ³×Æ®¿öÅ© Ä«µå¿¡¼ NetBIOS »ç¿ë ¼³Á¤À» ÇØÁ¦ÇØ¾ß ÇÕ´Ï´Ù.
-
¸ðµç ³ëµå¿¡¼ ½Ã½ºÅÛ ·Î±×¸¦ ºñ¿ì°í ´Ù½Ã Ç¥½ÃÇß´ÂÁö È®ÀÎÇÕ´Ï´Ù. ¼³Ä¡¸¦ ÁøÇàÇϱâ Àü¿¡ ·Î±×¿¡ ¿À·ù ¸Þ½ÃÁö°¡ ¾ø¾î¾ß ÇÕ´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering) ¼³Ä¡
Microsoft Windows NT¢ç 4.0 Enterprise Edition¿¡ Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡¿¡¼ ¼³¸íÇÏ´Â ¼ø¼´ë·Î ÇÁ·Î±×·¥À» ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. Microsoft Windows¢ç 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¿¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÒ ¶§´Â ¾Æ·¡ÀÇ ´Ü°è°¡ Àû¿ëµÇÁö ¾Ê½À´Ï´Ù.
ÁÖÀÇ: ¾Æ·¡¿¡¼ ¼³¸íÇÏ´Â ¼ø¼´ë·Î ÇÁ·Î±×·¥À» ¼³Ä¡ÇÏÁö ¾ÊÀ¸¸é ¼ÒÇÁÆ®¿þ¾î Á¦Ç°À» ¼³Ä¡ÇÏ´Â µ¥ ½ÇÆÐÇÏ°í µð½ºÅ©¸¦ ´Ù½Ã ÃʱâÈÇÑ ÈÄ ´Ù½Ã ¼³Ä¡ÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼º¿¡ SQL Server 2000À» ¼³Ä¡Çϱâ Àü¿¡ ½ÃÇèÆÇ ¹öÀüÀÇ SQL Server 2000À» ¾÷±×·¹À̵åÇØ¾ß ÇÕ´Ï´Ù.
Windows NT 4.0¿¡¼ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡ ´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
-
Microsoft Windows NT 4.0 Enterprise EditionÀ» ¼³Ä¡ÇÕ´Ï´Ù. Windows NT 4.0 Enterprise Edition¿¡´Â Microsoft Cluster Service(MSCS)¸¦ ¼³Ä¡ÇÏ´Â µ¥ ÇÊ¿äÇÑ Windows NT 4.0 ¼ºñ½º ÆÑ 3ÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.
-
Windows NT ¿É¼Ç ÆÑÀ» ¼³Ä¡ÇÒ °èȹÀÌ¸é ¼ºñ½º ÆÑ 4 ÀÌ»óÀ» ¼³Ä¡ÇÏÁö ¸¶½Ê½Ã¿À.
-
Microsoft Internet Information Server(IIS)¸¦ ¼³Ä¡ÇÏÁö ¸¶½Ê½Ã¿À.
Áß¿ä: IIS´Â ±âº»ÀûÀ¸·Î ¼³Ä¡µË´Ï´Ù. µû¶ó¼, Windows NT 4.0À» ¼³Ä¡ÇÒ ¶§ IIS ¿É¼ÇÀ» ÇØÁ¦ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
-
MSCS¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
-
Microsoft Internet Explorer ¹öÀü 5.0 ÀÌ»óÀ» ¼³Ä¡ÇÕ´Ï´Ù.
-
Microsoft Distributed Transaction Coordinator(MS DTC) ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ¸®¼Ò½º¸¦ »ý¼ºÇÒ ¼ö ÀÖµµ·Ï ¼öµ¿À¸·Î MSDTC ȣȯ ¸®¼Ò½º ±×·ìÀ» ¸¸µì´Ï´Ù. ÀÌ ±×·ìÀº IP ÁÖ¼Ò, ³×Æ®¿öÅ© À̸§ ¹× Ŭ·¯½ºÅÍ µð½ºÅ© ¸®¼Ò½º¸¦ Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ¼¼ Ç׸ñÀ» Æ÷ÇÔÇÏ´Â ±×·ìÀº ¸ðµÎ MSDTC¿Í ȣȯµË´Ï´Ù.
SQL Server ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ³ªÁß¿¡ MSDTC¸¦ ¼³Ä¡ÇÕ´Ï´Ù. µû¶ó¼ Windows NT 4.0 ¿É¼Ç ÆÑ¿¡¼ MSDTC ¿ÜÀÇ ±¸¼º ¿ä¼Ò°¡ ÇÊ¿äÇÒ ¶§¸¸ Windows NT 4.0 ¿É¼Ç ÆÑÀ» ¼³Ä¡ÇϽʽÿÀ.
-
Ãֽмºñ½º ÆÑÀÎ Windows NT 4.0 ¼ºñ½º ÆÑ 5¸¦ ¼³Ä¡ÇÕ´Ï´Ù. Create an uninstall directory¸¦ ´©¸£°í Year 2000 SetupÀ» ´©¸¥ ´ÙÀ½ Intel Service Pack install for Intel based systems È®ÀζõÀ» ¼±ÅÃÇÕ´Ï´Ù.
Microsoft Message Queue Server(MSMQ 1.0)³ª IIS´Â ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À. SQL Server 2000Àº MSMQ 1.0À» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. IIS ±â´ÉÀº Microsoft Windows NT ·Îµå ±ÕÇü Á¶Á¤ ¼ºñ½º(WLBS)¿Í ÇÔ²² »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. WLBS¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» º¸·Á¸é ¾Æ·¡ÀÇ Microsoft Windows NT Server À¥ »çÀÌÆ®¿¡¼ "WLBS Features Overview"¸¦ °Ë»öÇϽʽÿÀ.
5´Ü°è¸¦ ¼öÇàÇϱâ Àü¿¡ ¼û±è µð·ºÅ͸®ÀÎ "$NTServicePackUninstall$"ÀÇ À̸§À» "$NTServicePackUninstall$.¼ºñ½º_ÆÑ_¹øÈ£"·Î º¯°æÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¿©±â¼ ¼ºñ½º_ÆÑ_¹øÈ£´Â ¼ºñ½º ÆÑÀÇ ¹øÈ£ÀÔ´Ï´Ù. ¼ºñ½º ÆÑÀ» ¼³Ä¡ÇÑ ´ÙÀ½ »õ µð·ºÅ͸®¸¦ Ãß°¡ÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ¸é ½Ç¼ö·Î ¼³Ä¡ Á¦°Å µð·ºÅ͸®¸¦ µ¤¾î¾²Áö ¾Êµµ·Ï ¹æÁöÇÏ°í ±× µð·ºÅ͸®¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
-
SQL Server 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
Âü°í: ´Ù¸¥ ÀÀ¿ë ÇÁ·Î±×·¥À» ¼³Ä¡Çϱâ Àü¿¡ ÇÊ¿äÇÑ ¼¹ö Á¦Ç°À» Ãß°¡·Î ¼³Ä¡ÇϽʽÿÀ.
Microsoft Windows 2000¿¡¼ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡ ´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
-
±âº»ÀûÀ¸·Î ¼³Ä¡µÇ´Â ÀÀ¿ë ÇÁ·Î±×·¥À» ¸ðµÎ Àû¿ëÇÏ¿© Windows 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
-
ù ¹øÂ° ³ëµå¿¡ Windows 2000À» ¼³Ä¡ÇÑ ÈÄ MSCS¸¦ ¼³Ä¡Çϱâ Àü¿¡ ½ÃÀÛÀ» ´©¸£°í ÇÁ·Î±×·¥, °ü¸® µµ±¸¸¦ Â÷·Ê·Î °¡¸®Å² ´ÙÀ½ ¼¹ö ±¸¼ºÀ» ´©¸¨´Ï´Ù.
- °í±Þ¿¡¼ Ŭ·¯½ºÅÍ ¼ºñ½º¸¦ ´©¸¥ ´ÙÀ½ ¿À¸¥ÂÊ Ã¢¿¡¼ ÀÚ¼¼È÷ ¾Ë¾Æº¾´Ï´Ù¸¦ ´©¸¨´Ï´Ù.
-
Windows 2000 µµ¿ò¸» ¸Þ´º¿¡¼ "Windows Ŭ·¯½ºÅ͸µ" Ç׸ñÀÇ 2¹øÀ» ÀнÀ´Ï´Ù. Windows Ŭ·¯½ºÅ͸µÀº Windows 2000À» ¼³Ä¡ÇÏ´Â µ¿¾È SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú ÇÔ²² »ç¿ëµË´Ï´Ù. "Windows Ŭ·¯½ºÅ͸µ" Ç׸ñÀÇ Áöħ¿¡ µû¶ó MSCS¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
Áß¿ä: "Windows Ŭ·¯½ºÅ͸µ °èȹ\¿ä±¸ »çÇ×" Ç׸ñ¿¡¼ ¼¹ö Ŭ·¯½ºÅÍ¿¡ ´ëÇÑ ¼³¸íÀ» Àаí "°Ë»ç ¸ñ·Ï: ¼¹ö Ŭ·¯½ºÅÍ ¸¸µé±â"¿¡ ³ª¿Â ¼¹ö Ŭ·¯½ºÅÍ °Ë»ç ¸ñ·ÏÀ» µû¶ó¾ß ÇÕ´Ï´Ù. "°Ë»ç ¸ñ·Ï: ¼¹ö Ŭ·¯½ºÅÍ ¸¸µé±â" Ç׸ñÀº ¼¹ö Ŭ·¯½ºÅÍ¿¡ ´ëÇÑ Ç׸ñ¿¡¼ "¼¹ö Ŭ·¯½ºÅÍ Àý\°Ë»ç ¸ñ·Ï" ¾Æ·¡¿¡ ÀÖ½À´Ï´Ù.
-
MSCS¸¦ ¼³Ä¡ÇÑ ´ÙÀ½¿¡´Â Ŭ·¯½ºÅÍ¿¡¼ ½ÇÇàÇÒ MSDTC¸¦ ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. MSDTC¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
- ½ÃÀÛ ¸Þ´º¿¡¼ ÇÁ·Î±×·¥, °ü¸® µµ±¸, Ŭ·¯½ºÅÍ °ü¸®ÀÚ¸¦ Â÷·Ê·Î °¡¸®Å² ´ÙÀ½ ±×·ì º¸±â¿¡¼ Ŭ·¯½ºÅÍ ±×·ìÀ» ´©¸¨´Ï´Ù. ±×·ìÀÌ MSDTC ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏ´Â °æ¿ì¿¡´Â 9´Ü°è·Î °Ç³Ê¶Ý´Ï´Ù. ±×·ìÀÌ MSDTC ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏÁö ¾ÊÀ¸¸é °è¼ÓÇÏ¿© 7´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
- ½ÃÀÛ ¸Þ´º¿¡¼ ½ÇÇàÀ» ´©¸¨´Ï´Ù. ½ÇÇà ´ëÈ »óÀÚ¿¡ ¾Æ·¡ ¸í·ÉÀ» ÀÔ·ÂÇϰí
cmd
È®ÀÎÀ» ´©¸¨´Ï´Ù. ¸í·É ÇÁ·ÒÇÁÆ® â¿¡¼ ¸í·ÉÁÙ¿¡ ¾Æ·¡¿Í °°ÀÌ ÀÔ·ÂÇÕ´Ï´Ù.
Comclust.exe
-
Ŭ·¯½ºÅÍÀÇ ³ª¸ÓÁö ³ëµå¿¡ ´ëÇØ ÇÑ ¹ø¿¡ ÇÑ ³ëµå¾¿ 7´Ü°è¸¦ ¹Ýº¹ÇÕ´Ï´Ù.
-
SQL Server 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
Âü°í: »ç¿ëÀÚ ÀÀ¿ë ÇÁ·Î±×·¥À» ¼³Ä¡Çϱâ Àü¿¡ ÇÊ¿äÇÑ ¼¹ö Á¦Ç°À» Ãß°¡·Î ¼³Ä¡ÇϽʽÿÀ.
Cluster Disk Selection ȸé
»õ °¡»ó ¼¹ö¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È ¶Ç´Â Ŭ·¯½ºÅ͸¦ ¾÷±×·¹À̵åÇÏ´Â µ¿¾È
Cluster Disk Selection ȸ鿡¼ Ŭ·¯½ºÅÍ ±×·ìÀ» ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. Ŭ·¯½ºÅÍ ±×·ìÀº ±×·ì¿¡ Æ÷ÇÔµÈ Çϳª ÀÌ»óÀÇ °øÀ¯ Ŭ·¯½ºÅÍ µð½ºÅ©·Î ÀÌ·ç¾îÁö¸ç Microsoft¢ç SQL Server¢â °¡»ó ¼¹ö¸¦ Çϳª¸¸ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù.
Cluster Disk Selection ȸ鿡´Â ÀÌ¹Ì °øÀ¯ Ŭ·¯½ºÅÍ µð½ºÅ©°¡ ¸®¼Ò½º·Î Ãß°¡µÈ ±×·ì¸¸ ³ªÅ¸³³´Ï´Ù. Ŭ·¯½ºÅÍ µð½ºÅ©¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº º» ¹®¼ÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â" ÀýÀ̳ª SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
ÁÖÀÇ: ¸ñ·Ï¿¡¼ ¸¶Áö¸· ±×·ìÀÎ Äõ·³ µð½ºÅ©´Â Ư¼öÇÑ ¸®¼Ò½º·Î Ãë±ÞÇØ¾ß ÇϹǷΠ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À. Äõ·³(Quorum) µð½ºÅ©¸¦ ¼±ÅÃÇÏ¸é °æ°í ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼ "Quorum Disk Selection Warning" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
ÀÛÀº Ŭ·¯½ºÅ͸¦ »ç¿ëÇÒ ¶§´Â Äõ·³(Quorum) µð½ºÅ©°¡ À¯ÀÏÇÑ ¼±Åà Ç׸ñÀÏ ¼öµµ ÀÖ½À´Ï´Ù. Äõ·³(Quorum) µð½ºÅ©´Â Å×½ºÆ® ¸ñÀûÀ¸·Î ¶Ç´Â Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» Ž»öÇϱâ À§ÇÑ ¸ñÀûÀ¸·Î¸¸ »ç¿ëÇϽʽÿÀ.
Áß¿ä: ÇÁ·Î´ö¼Ç(Production) ¸ñÀûÀ¸·Î Äõ·³(Quorum) ±×·ìÀ» »ç¿ëÇÏÁö ¸¶½Ê½Ã¿À.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¼³Ä¡
Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡ÇÒ ¶§ ¾Æ·¡¿Í °°Àº »çÇ×À» µû¶ó¾ß ÇÕ´Ï´Ù.
-
¿î¿µ üÁ¦°¡ ¿Ã¹Ù¸£°Ô ¼³Ä¡µÇ¾î ÀÖ°í Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» Áö¿øÇϵµ·Ï ¼³°èµÇ¾î ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡Çϱâ Àü¿¡ ÇØ¾ß ÇÒ ÀÛ¾÷¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Before Installing Failover Clustering" Ç׸ñÀ̳ª º» ¹®¼ ¾ÕºÎºÐÀÇ "¼³Ä¡ Àü °Ë»ç ¸ñ·Ï" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ. ¼³Ä¡ ¼ø¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº º» ¹®¼ ¾ÕºÎºÐÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering) ¼³Ä¡" Àý ¶Ç´Â SQL Server 2000 Books OnlineÀÇ "Installing Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
»ç¿ëÇÏ·Á´Â SQL Server µµ±¸, ±â´É ¹× ±¸¼º ¿ä¼Ò°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡¼ Áö¿øµÇ´ÂÁöÀÇ ¿©ºÎ¸¦ °í·ÁÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Support" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
´ÙÀ½Àº Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ Áö¿øµÇ´Â µµ±¸, ±â´É ¹× ±¸¼º ¿ä¼Ò¸¦ ¿ä¾àÇÑ °ÍÀÔ´Ï´Ù.
Ç¥ Ãà¼ÒÇ¥ È®´ë
| Microsoft °Ë»ö ¼ºñ½º |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| º¹¼ö ÀνºÅϽº |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| SQL Server Enterprise Manager(¿£ÅÍÇÁ¶óÀÌÁî °ü¸®ÀÚ) |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| ¼ºñ½º Á¦¾î °ü¸®ÀÚ |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| º¹Á¦ |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| SQL Profiler(ÇÁ·ÎÇÊ·¯) |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| SQL Query Analyzer(Äõ¸® ºÐ¼®±â) |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
| SQL ¸ÞÀÏ |
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
|
-
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)ÀÌ »ç¿ëÇÏ·Á´Â Á¾¼ÓµÇ´ÂÁöÀÇ ¿©ºÎ¸¦ °í·ÁÇÕ´Ï´Ù. Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú »óÈ£ ÀÛ¿ëÇÏ´Â Á¦Ç°Àº ¿©·¯ °¡Áö°¡ ÀÖ½À´Ï´Ù. Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ Á¦´ë·Î ÀÛµ¿ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú ´Ù¸¥ Á¦Ç° »çÀÌÀÇ ±âº»ÀûÀÎ Á¾¼Ó¼ºÀ» ÀÌÇØÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
»õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ¹æ¹ýÀ» °í·ÁÇÕ´Ï´Ù. »õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼ºÀ» ¸¸µå´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
SQL Server 6.5 ¶Ç´Â SQL Server 7.0 Ŭ·¯½ºÅ͸¦ SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)·Î ¾÷±×·¹À̵åÇϱâ À§ÇÑ ÁöħÀ» °ËÅäÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Upgrading to a SQL Server 2000 Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
- Microsoft Distributed Transaction Coordinator(MSDTC) SQL Server 2000ÀÌ ÀϺΠº¹Á¦ ±â´É°ú ºÐ»ê Äõ¸® ¹× 2´Ü°è Ä¿¹Ô Æ®·£Àè¼ÇÀ» ¼öÇàÇÏ·Á¸é Ŭ·¯½ºÅÍ¿¡ Microsoft Distributed Transaction Coordinator(MSDTC)°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. Microsoft Windows¢ç 2000À» ¼³Ä¡Çϰí Ŭ·¯½ºÅ͸¦ ±¸¼ºÇÑ ´ÙÀ½¿¡´Â º» ¹®¼ÀÇ ¾ÕºÎºÐ¿¡¼ ¼³¸íÇÑ °Íó·³ ¸ðµç ³ëµå¿¡¼ Ŭ·¯½ºÅÍ ¸¶¹ý»ç(Comclust.exe)¸¦ ½ÇÇàÇÏ¿© Ŭ·¯½ºÅÍµÈ ¸ðµå¿¡¼ MSDTC¸¦ ½ÇÇàÇϵµ·Ï ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ¹æ¹ý
Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ ½ÇÇàµÉ °¡»ó ¼¹ö¸¦ ¸¸µé¾î ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. SQL Server¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È °¡»ó ¼¹ö¸¦ ¸¸µì´Ï´Ù. Microsoft Windows NT¢ç 4.0 ¶Ç´Â Microsoft Windows¢ç 2000Àº °¡»ó ¼¹ö¸¦ Á¦°øÇÏÁö ¾Ê½À´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé·Á¸é ¼ºñ½º·Î ·Î±×¿ÂÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ¸ðµç ÄÄÇ»ÅÍ¿¡¼ ¿î¿µ üÁ¦ÀÇ ÀϺηΠµ¿ÀÛÇÒ ¼ö ÀÖ´Â ±ÇÇÑÀ» °¡Áø ·ÎÄà °ü¸®ÀÚ¿©¾ß ÇÕ´Ï´Ù.
°¡»ó ¼¹öÀÇ ¿ä¼Ò
°¡»ó ¼¹ö´Â ¾Æ·¡¿Í °°Àº ¿ä¼Ò·Î ±¸¼ºµË´Ï´Ù.
-
Microsoft Cluster Service(MSCS) Ŭ·¯½ºÅÍ ±×·ì¿¡ Æ÷ÇÔµÈ Çϳª ¶Ç´Â ¿©·¯ µð½ºÅ©ÀÇ Á¶ÇÕ
°¢ MSCS Ŭ·¯½ºÅÍ ±×·ìÀº °¡»ó SQL Server¸¦ Çϳª¸¸ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù.
-
°¢ °¡»ó ¼¹öÀÇ ³×Æ®¿öÅ© À̸§. ÀÌ ³×Æ®¿öÅ© À̸§Àº °¡»ó ¼¹ö À̸§ÀÔ´Ï´Ù.
-
°¢ °¡»ó ¼¹ö¿¡ ¿¬°áÇÏ´Â µ¥ »ç¿ëµÇ´Â Çϳª ÀÌ»óÀÇ IP ÁÖ¼Ò
-
SQL Server ¸®¼Ò½º, SQL Server Agent ¸®¼Ò½º ¹× Àüü ÅØ½ºÆ® ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏ´Â SQL Server 2000ÀÇ ÀνºÅϽº Çϳª
°ü¸®ÀÚ°¡ °¡»ó ¼¹ö ³»ÀÇ SQL Server 2000 ÀνºÅϽº¸¦ Á¦°ÅÇÏ¸é ¸ðµç IP ÁÖ¼Ò¿Í ³×Æ®¿öÅ© À̸§À» Æ÷ÇÔÇÏ¿© °¡»ó ¼¹öµµ MSCS Ŭ·¯½ºÅÍ ±×·ì¿¡¼ Á¦°ÅµË´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)´Â Ŭ·¯½ºÅÍÀÇ ³ëµå¿¡ Âü¿©ÇÏ´Â Çϳª ÀÌ»óÀÇ ½ÇÁ¦ Windows 2000 Advanced Server, Windows 2000 Datacenter Server ¼¹ö ¶Ç´Â Windows NT 4.0 Enterprise Edition ¼¹ö¿¡¼ ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª SQL Server °¡»ó ¼¹ö´Â ³×Æ®¿öÅ©¿¡¼ Ç×»ó ´ÜÀÏ Windows 2000 Advanced Server ¼¹ö, Windows 2000 Datacenter Server ¼¹ö ¶Ç´Â Microsoft Windows NT 4.0 Enterprise Edition ¼¹ö·Î ³ªÅ¸³³´Ï´Ù.
°¡»ó ¼¹ö À̸§ ÁöÁ¤
SQL Server 2000Àº Àå¾Ö Á¶Ä¡(Failover) ÀÌÈÄ Á¤»óÀûÀÎ ÀÛµ¿ÀÌ °è¼ÓµÇµµ·Ï Çϱâ À§ÇØ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ³»ÀÇ Æ¯Á¤ ·¹Áö½ºÆ®¸® Ű¿Í ¼ºñ½º À̸§¿¡ ÀÇÁ¸ÇÕ´Ï´Ù. µû¶ó¼ ±âº» ÀνºÅϽº¸¦ Æ÷ÇÔÇÏ¿© SQL Server 2000ÀÇ ÀνºÅϽº¿¡ ÁöÁ¤ÇÏ´Â À̸§Àº Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ³»ÀÇ ¸ðµç °¡»ó ¼¹ö»Ó¸¸ ¾Æ´Ï¶ó Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ±¸¼ºÇÏ´Â ¸ðµç ³ëµå¿¡¼ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ¸ðµç ÀνºÅϽº°¡ ´ÜÀÏ ¼¹ö·Î Àå¾Ö Á¶Ä¡(Failover)µÇ¸é ÀνºÅϽºÀÇ ¼ºñ½º À̸§°ú ·¹Áö½ºÆ®¸® ۰¡ Ãæµ¹ÇÕ´Ï´Ù. INST1ÀÌ °¡»ó ¼¹ö VIRTSRV1¿¡¼ ¸í¸íµÈ ÀνºÅϽºÀ̸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ´Ù¸¥ ³ëµå¿¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼ºÀÇ ÀϺημ ¶Ç´Â µ¶¸³Çü ¼³Ä¡·Î¼ INST1À̶ó´Â À̸§À» °¡Áø ¸í¸íµÈ ÀνºÅϽº°¡ ÀÖÀ» ¼ö ¾ø½À´Ï´Ù.
¶ÇÇÑ, °¡»ó ¼¹ö¿¡¼ ½ÇÇàµÇ´Â SQL Server 2000ÀÇ Å¬·¯½ºÅÍµÈ ÀνºÅϽº¿¡ ¿¬°áÇϱâ À§ÇØ VIRTUAL_SERVER\ÀνºÅϽº_À̸§ ¹®ÀÚ¿À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. Ŭ·¯½ºÅÍµÈ ÀνºÅϽº°¡ ÀÖ´Â SQL Server 2000ÀÇ ÀνºÅϽº¿¡ ÄÄÇ»ÅÍ À̸§À» »ç¿ëÇÏ¿© ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù. SQL Server 2000Àº ·ÎÄà ¼¹öÀÇ IP ÁÖ¼Ò¿¡¼ ¼ö½Å ´ë±âÇÏÁö ¾Ê½À´Ï´Ù. SQL Server 2000À» À§ÇÑ °¡»ó ¼¹ö¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È »ý¼ºµÈ Ŭ·¯½ºÅÍµÈ IP ÁÖ¼Ò¿¡¼¸¸ ¼ö½Å ´ë±âÇÕ´Ï´Ù.
»ç¿ë ½Ã °í·Á »çÇ×
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé±â Àü¿¡ ¾Æ·¡¿Í °°Àº »çÇ×À» °í·ÁÇϽʽÿÀ.
-
Windows 2000 Address Windowing Extensions(AWE) API¸¦ »ç¿ëÇÏ¿© 3GB ÀÌ»óÀÇ ¸Þ¸ð¸®¸¦ ÀÌ¿ëÇÏ´Â °æ¿ì, SQL ServerÀÇ ÇÑ ÀνºÅϽº¿¡¼ ±¸¼ºÇÑ »ç¿ë °¡´ÉÇÑ ÃÖ´ë ¸Þ¸ð¸®¸¦ ´Ù¸¥ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)ÇÑ ÈÄ¿¡µµ °è¼Ó »ç¿ëÇÒ ¼ö ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Àå¾Ö Á¶Ä¡(Failover) ³ëµåÀÇ ½ÇÁ¦(Physical) ¸Þ¸ð¸®°¡ ¿ø·¡ ³ëµåÀÇ ¸Þ¸ð¸®º¸´Ù ÀÛÀ¸¸é SQL ServerÀÇ ÀνºÅϽº°¡ ½ÃÀÛµÇÁö ¾Ê°Å³ª ¿ø·¡ ³ëµå¿¡¼º¸´Ù ÀÛÀº ¸Þ¸ð¸®¸¦ »ç¿ëÇÏ¿© ½ÃÀÛµÉ ¼ö ÀÖ½À´Ï´Ù. ¾Æ·¡¿Í °°Àº »çÇ×À» È®ÀÎÇÕ´Ï´Ù.
-
Ŭ·¯½ºÅÍÀÇ °¢ ¼¹ö¿¡¼ ½ÇÁ¦(Physical) RAMÀÇ ¾çÀÌ µ¿ÀÏÇØ¾ß ÇÕ´Ï´Ù.
-
¸ðµç ÀνºÅϽºÀÇ ÃÖ´ë ¼¹ö ¸Þ¸ð¸® ¼³Á¤°ªÀÇ ÇÕ°è°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ °¢ °¡»ó ¼¹ö¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ´Â ÃÖ¼ÒÀÇ ½ÇÁ¦(Physical) RAM Å©±âº¸´Ù ÀÛ¾Æ¾ß ÇÕ´Ï´Ù.
AWE¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using AWE Memory on Windows 2000" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
º¹Á¦¸¦ À§ÇØ °í°¡¿ë¼º ¼¹ö°¡ ÇÊ¿äÇϸé Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¿¡¼ ¹èÆ÷ÀÚ¸¦ ±¸¼ºÇÒ ¶§ MSCS Ŭ·¯½ºÅÍ ÆÄÀÏ °øÀ¯¸¦ ½º³À¼¦ Æú´õ·Î »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¼¹ö¿¡ Àå¾Ö°¡ ¹ß»ýÇÏ¸é ¹èÆ÷ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÒ ¼ö ÀÖ°í ¹èÆ÷ÀÚ¿¡¼ º¹Á¦¸¦ °è¼Ó ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
¶ÇÇÑ, °Ô½Ã(Publication)¸¦ ¸¸µé ¶§ ½º³À¼¦ ÆÄÀÏÀÇ Ãß°¡ ÀúÀå¼Ò¸¦ À§ÇØ MSCS Ŭ·¯½ºÅÍ ÆÄÀÏ °øÀ¯¸¦ ÁöÁ¤Çϰųª MSCS Ŭ·¯½ºÅ͸¦ ±¸µ¶ÀÚ(Subscriber)°¡ ½º³À¼¦À» Àû¿ëÇÏ´Â À§Ä¡·Î ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ·¸°Ô Çϸé Ŭ·¯½ºÅÍÀÇ ¸ðµç ³ëµå¿Í ½º³À¼¦ ÆÄÀÏ¿¡ ¾×¼¼½ºÇØ¾ß ÇÏ´Â ¸ðµç ±¸µ¶ÀÚ(Subscriber)°¡ ½º³À¼¦ ÆÄÀÏÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Publishers, Distributors, and Subscribers" ¹× "Alternate Snapshot Locations" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¿¡ ¾Ïȣȸ¦ »ç¿ëÇÏ·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ¸ðµç ³ëµå¿¡¼ °¡»ó ¼¹öÀÇ Á¤½Ä DNS À̸§À» »ç¿ëÇÏ¿© ¼¹ö ÀÎÁõ¼¸¦ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, À̸§ÀÌ test1.widgets.corp.microsoft.com ¹× test2.widgets.corp.microsoft.comÀÎ µÎ ³ëµå·Î ÀÌ·ç¾îÁø Ŭ·¯½ºÅÍ¿Í °¡»ó SQL ServerÀÎ "Virtsql"ÀÌ ÀÖ´Â °æ¿ì¿¡´Â "virtsql.widgets.corp.microsoft.com"ÀÇ ÀÎÁõ¼¸¦ ±¸ÇÏ¿© µÎ ³ëµå ¸ðµÎ¿¡ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ±×·± ´ÙÀ½ ¼¹ö ³×Æ®¿öÅ© À¯Æ¿¸®Æ¼¿¡¼ Force protocol encryption È®ÀζõÀ» ¼±ÅÃÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¾ÏÈ£ÈÇÕ´Ï´Ù.
-
SQL Server¿¡¼ BUILTIN/Administrators °èÁ¤À» Á¦°ÅÇÏÁö ¸¶½Ê½Ã¿À. ISALIVE ½º·¹µå´Â SQL Server ¼ºñ½º °èÁ¤ÀÌ ¾Æ´Ñ Ŭ·¯½ºÅÍ ¼ºñ½º °èÁ¤ÀÇ ÄÁÅØ½ºÆ®¿¡¼ ½ÇÇàµË´Ï´Ù. Ŭ·¯½ºÅÍ ¼ºñ½º´Â Ŭ·¯½ºÅÍÀÇ °¢ ³ëµå¿¡¼ °ü¸®ÀÚ ±×·ìÀÇ ÀϺο©¾ß ÇÕ´Ï´Ù. BUILTIN/Administrators °èÁ¤À» Á¦°ÅÇϸé ISALIVE ½º·¹µå°¡ ´õ ÀÌ»ó Æ®·¯½ºÆ®µÈ ¿¬°áÀ» ¸¸µé ¼ö ¾ø°í °¡»ó ¼¹ö¿¡ ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â: ½ÇÁ¦ ¼³Ä¡
¼³Ä¡ ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ±âº» ´Ü°è´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
-
Ŭ·¯½ºÅÍ µð½ºÅ© ¸®¼Ò½º, IP ÁÖ¼Ò, ³×Æ®¿öÅ© À̸§ µî, °¡»ó ¼¹ö¸¦ ¸¸µå´Â µ¥ ÇÊ¿äÇÑ Á¤º¸¿Í Àå¾Ö Á¶Ä¡(Failover)¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â ³ëµå¸¦ È®ÀÎÇÕ´Ï´Ù.
Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ »ç¿ëÇÒ Å¬·¯½ºÅÍ µð½ºÅ©´Â ¸ðµÎ ´ÜÀÏ Å¬·¯½ºÅÍ ±×·ì¿¡ ÀÖ°í ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ´Â ³ëµå°¡ ¼ÒÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ±¸¼ºÀº ¼³Ä¡ ÇÁ·Î±×·¥À» ½ÇÇàÇϱâ Àü¿¡ ÀÌ·ç¾îÁ®¾ß ÇÕ´Ï´Ù. Windows NT 4.0 ¶Ç´Â Windows 2000¿¡¼ Ŭ·¯½ºÅÍ °ü¸®ÀÚ¸¦ »ç¿ëÇÏ¿© ÀÌ·¸°Ô ±¸¼ºÇÕ´Ï´Ù. ¼³Ä¡ÇÒ °¢ °¡»ó ¼¹ö¸¶´Ù MSCS ±×·ìÀÌ Çϳª¾¿ ÇÊ¿äÇÕ´Ï´Ù.
-
¼³Ä¡ ÇÁ·Î±×·¥À» ½ÃÀÛÇÕ´Ï´Ù. ÇÊ¿äÇÑ Á¤º¸¸¦ ¸ðµÎ ÀÔ·ÂÇÏ°í ³ª¸é ¼³Ä¡ ÇÁ·Î±×·¥Àº Ŭ·¯½ºÅÍ¿¡ Æ÷ÇԵǴ °¢ ÄÄÇ»ÅÍÀÇ ·ÎÄà µð½ºÅ©¿¡ SQL Server ¹ÙÀ̳ʸ®ÀÇ »õ ÀνºÅϽº¸¦ ¼³Ä¡Çϰí ÁöÁ¤µÈ Ŭ·¯½ºÅÍ µð½ºÅ©¿¡ ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÕ´Ï´Ù. ¹ÙÀ̳ʸ®´Â °¢ Ŭ·¯½ºÅÍ ³ëµå¿¡¼ µ¿ÀÏÇÑ °æ·Î¿¡ ¼³Ä¡µÇ¹Ç·Î °¢ ³ëµå°¡ Ŭ·¯½ºÅÍÀÇ ´Ù¸¥ ¸ðµç ³ëµå¿Í µ¿ÀÏÇÑ ·ÎÄà µå¶óÀÌºê ¹®ÀÚ¸¦ »ç¿ëÇÏ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.
SQL Server 2000¿¡¼´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È µ¥ÀÌÅͺ£À̽º¸¸ÀÌ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù. SQL Server 6.5 ¹× SQL Server 7.0¿¡¼´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È SQL Server µ¥ÀÌÅͺ£À̽º¿Í ¹ÙÀ̳ʸ® ¸ðµÎ°¡ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù.
¾î¶² ÀÌÀ¯·Îµç SQL Server¸¦ ºñ·ÔÇÏ¿© ¸®¼Ò½º¿¡ Àå¾Ö°¡ ¹ß»ýÇϸé SQL Server, SQL Server Agent, Àüü ÅØ½ºÆ® °Ë»ö ¼ºñ½º ¹× Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±×·ìÀÇ ¸ðµç ¼ºñ½º°¡ °¡»ó ¼¹ö¿¡ Á¤ÀÇµÈ »ç¿ë °¡´ÉÇÑ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù.
-
SQL Server 2000¿¡¼´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È µ¥ÀÌÅͺ£À̽º¸¸ÀÌ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù. SQL Server 6.5 ¹× SQL Server 7.0¿¡¼´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È SQL Server µ¥ÀÌÅͺ£À̽º¿Í ¹ÙÀ̳ʸ® ¸ðµÎ°¡ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù.
SQL Server 2000ÀÇ ÀνºÅϽº Çϳª¸¦ ¼³Ä¡ÇÏ¿© »õ °¡»ó ¼¹ö¿Í ¸ðµç ¸®¼Ò½º¸¦ »ý¼ºÇÕ´Ï´Ù.
ÂüÁ¶
»õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ±¸¼ºÇÏ´Â ¹æ¹ý ¹× Ŭ·¯½ºÅ͸µ°ú °ü·ÃµÈ ´Ù¸¥ ÁÖÁ¦¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼ ¾Æ·¡ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
-
Upgrading to a SQL Server 2000 Failover Cluster
-
How to install a one-node failover cluster
-
Failover Clustering FAQ
-
Adding/removing nodes
-
Maintaining
-
Full-text queries
-
Troubleshooting
±â¼ú ÀÚ·á: 243218 - ¸¶Áö¸· °ËÅä: 2007³â 10¿ù 26ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 3.1
º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
- Microsoft Windows 2000 Advanced Server
- Microsoft Windows 2000 Datacenter Server
- Microsoft SQL Server 2000 Enterprise Edition
| kbtshoot kbsqlserv2000 kbinterop kbproductlink KB243218 |