Oracle RAC LoadBalance
LoadBalance ¾ÍÊǰѸºÔØÆ½¾ùµÄ·ÖÅäµ½¼¯ÈºÖеĸ÷¸ö½Úµã£¬´Ó¶øÌá¸ßÕûÌåµÄÍÌÍÂÄÜÁ¦¡£ Oracle 10g RAC ÌṩÁËÁ½ÖÖ²»Í¬µÄ·½·¨À´·ÖÉ¢¸ºÔØ£º
1. ͨ¹ýConnection Balancing£¬°´ÕÕijÖÖËã·¨°ÑÓû§·ÖÅäµ½²»Í¬µÄ½Úµã¡£Ò²¿ÉÈÏΪÊÇ´¿¼¼ÊõµÄ·ÖÉ¢¸ºÔØ¡£
2. ͨ¹ýService£¬ÔÚÓ¦ÓòãÉϽøÐзÖÉ¢£¬Ò²¿ÉÈÏΪÊÇÃæÏóÒµÎñµÄ·ÖÉ¢¸ºÔØ¡£
Ò»£®Connection Balancing
Connection Balancing ÕâÖÖ¸ºÔؾùºâÊÇÔÚÓû§Á¬½ÓÕâ¸ö²ã´Î½øÐеģ¬Ò²¾ÍÊÇÔÚÓû§ÇëÇó½¨Á¢Á¬½Óʱ£¬¸ù¾Ýÿ¸ö½ÚµãµÄ¸ºÔؾö¶¨°ÑÁ¬½Ó·ÖÅ䏸ÄĸöʵÀý£¬¶øÒ»µ©Á¬½Ó½¨Á¢Ö®ºó£¬»á»°µÄËùÓвÙ×÷¾Í¶¼ÔÚÕâ¸öʵÀýÉÏÍê³É£¬¶ø²»»áÔÙ·ÖÅɸøÆäËû½ÚµãÁË¡£
Connection Balancing Óпͻ§¶ËºÍ·þÎñ¶ËÁ½ÖÖʵÏÖ·½·¨¡£
1.1 ¿Í»§¶Ë¾ùºâ£¨Client-Side LB£©
¿Í»§¶Ë¾ùºâ£¨Client-Side LB£©ÊÇOracle 8 ʹÓõķ½·¨£¬ÅäÖ÷½·¨ÊÇÔÚ¿Í»§¶ËµÄtnsnames.ora ÎļþÖмÓÈ룺
LOAD_BALANCE=YES ÌõÄ¿¡£µ±¿Í»§¶Ë·¢ÆðÁ¬½Óʱ£¬»á´ÓµØÖ·ÁбíÖÐËæ»úµÄѡȡһ¸ö£¬ÔÚʹÓÃËæ¼´Ëã·¨°ÑÁ¬½Ó ÇëÇó·ÖÅäµ½¸÷¸öʵÀý¡£
Ò»¸öClint-Side LBµÄTNS ÅäÖÃÎļþÈçÏ£º
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC)
)
)
)
×¢£º rac1-vip ÐèÒªÌí¼Óµ½hosts ÎļþÖÐ
ÕâÖÖ·½·¨È±µãºÜÃ÷ÏÔ£¬ÒòΪÔÚ·ÖÅäÁ¬½ÓʱûÓп¼ÂÇÿ¸ö½ÚµãµÄÕæÊµ¸ºÔØ£¬×îºó·ÖÅä½á¹û²»Ò»¶¨ÊÇÆ½ºâµÄ£»²¢ÇÒËæ¼´Ëã·¨ÐèÒª³¤Ê±¼äƬ£¬Èç¹ûÔÚ¶Ìʱ¼äÄÚͬʱ·¢Æð¶à¸öÁ¬½Ó£¬ÕâЩÁ¬½ÓÓпÉÄܶ¼±»·ÖÅäµ½Ò»¸ö½ÚµãÉÏ£¬ÉõÖÁ¸ü»µµÄÇé¿öÏ£¬Á¬½Ó¿ÉÄܱ»·ÖÅäµ½¹ÊÕϽڵãÉÏ¡£Òò´ËOracle ÒýÈëÁË·þÎñ¶Ë¾ùºâ(Sevice-Side LB)·½Ê½¡£
1.2 ·þÎñÆ÷¶Ë¾ùºâ£¨Server-Side LB£©
Server-Side&
Ïà¹ØÎĵµ£º
¿ªÆô£º
net start oracledbconsoleorcl
net start oracleOraDb10g_home1iSQL*Plus
net start oracleOraDb10g_home1TNSListener
net start oracleServiceORCL
net start oraclejobschedulerorcl //¿ÉÒÔ½ûÓÃ
¹Ø±Õ£º
net stop oracledbconsoleorcl
net stop oracleOraDb10g_home1iSQL*Plus
net stop oracleOraDb10g_h ......
author£ºskate
time£º2010/03/04
oracleÊý¾Ý¿â¼¶±ðÓÅ»¯·ÖÎö¹¤¾ß½éÉÜ
µ±ÎÒÃǶÔÊý¾Ý¿âÓÅ»¯Õï¶Ïʱ£¬ÐèÒªÊÕ¼¯ÏàÓ¦µÄÐÅÏ¢ÒÔ¹©²Î¿¼£¬´Ó¸öÈ˵ÄʹÓþÑéÀ´Ëµ£¬ÕâÖÖͳ¼ÆÊý¾Ý·ÖΪÁ½´óÀà
Ò»ÀàÊÇÊý¾Ý¿â¼¶±ðµÄͳ¼ÆÐÅÏ¢
¶þÀàÊÇos¼¶±ðµÄͳ¼ÆÐÅÏ¢
ÏÂÃæ¾Í·Ö±ð½éÉÜÔÚ²»Í¬µÄ¼¶±ðÏ£¬³£ÓÃʲô¹¤¾ßÀ´ÊÕ¼¯ÐÅÏ¢°ïÖúÓÅ»¯Õï¶Ï
Ê×ÏÈÊÇoracleÊý¾ ......
·1979ÄêµÄÏļ¾£¬RSI·¢²¼ÁËOracleµÚ¶þ°æ
·1983Äê3Ô£¬RSI·¢²¼ÁËOracleµÚÈý°æ
´ÓÏÖÔÚÆðOracle²úÆ·ÓÐÁËÒ»¸ö¹Ø¼üµÄÌØÐÔ:¿ÉÒÆÖ²ÐÔ
·1984Äê10Ô£¬Oracle·¢²¼Á˵Ú4°æ²úÆ·
ÕâÒ»°æÔö¼ÓÁ˶ÁÒ»ÖÂÐÔÕâ¸öÖØÒªÌØÐÔ
·1985Ä꣬Oracle·¢²¼ÁË5.0°æ
Õâ¸ö°æ±¾ËãµÃÉÏÊÇOracleÊý¾Ý¿âµÄÎȶ¨°æ±¾¡£ÕâÒ²ÊÇÊ ......
ʲôÊÇË÷Òý
¡¡¡¡
¡¡¡¡Ë÷ÒýÊǽ¨Á¢ÔÚ±íµÄÒ»Áлò¶à¸öÁÐÉϵĸ¨Öú¶ÔÏó£¬Ä¿µÄÊǼӿì·ÃÎʱíÖеÄÊý¾Ý£»
¡¡¡¡
¡¡¡¡Oracle´æ´¢Ë÷ÒýµÄÊý¾Ý½á¹¹ÊÇB*Ê÷£¬Î»Í¼Ë÷ÒýÒ²ÊÇÈç´Ë£¬Ö»²»¹ýÊÇÒ¶×ӽڵ㲻ͬB*ÊýË÷Òý£»
¡¡¡¡
¡¡¡¡Ë÷ÒýÓɸù½Úµã¡¢·ÖÖ§½ÚµãºÍÒ¶×Ó½Úµã×é³É£¬Éϼ¶Ë÷Òý¿é°üº¬Ï¼¶Ë÷Òý¿éµÄË÷ÒýÊý¾Ý£¬Ò¶½Úµã°üº¬Ë÷ÒýÊý¾ÝºÍÈ·¶¨ÐÐ ......