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&
Ïà¹ØÎĵµ£º
¿ª·ÅÐÔ ¡¡¡¡SQL Server
¡¡¡¡Ö»ÄÜÔÚWindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT serverÖ»ÊʺÏÖÐСÐÍÆóÒµ¡£¶øÇÒWindowsƽ̨µÄ¿É¿¿ÐÔ£¬°²È«ÐÔºÍÉìËõÐÔÊǷdz£ÓÐÏ޵ġ£Ëü²»ÏóUnixÄÇÑù¾Ã¾¿¼Ñ飬ÓÈÆäÊÇÔÚ´¦Àí´óÊý¾ÝÁ¿µÄ¹Ø¼üÒµÎñʱ¡£
¡¡¡¡Oracle
......
1.DUAL±íµÄÓÃ;
Dual ÊÇ OracleÖеÄÒ»¸öʵ¼Ê´æÔÚµÄ±í£¬ÈκÎÓû§¾ù¿É¶ÁÈ¡£¬³£ÓÃÔÚûÓÐÄ¿±ê±íµÄSelectÓï¾ä¿éÖÐ
--²é¿´µ±Ç°Á¬½ÓÓû§
SQL> select user from dual;
USER
------------------------------
SYSTEM
--²é¿´µ±Ç°ÈÕÆÚ¡¢Ê±¼ä
SQL> select sysdate from dual;
SYSDATE
-----------
2007-1-2 ......
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......
ʲôÊÇË÷Òý
¡¡¡¡
¡¡¡¡Ë÷ÒýÊǽ¨Á¢ÔÚ±íµÄÒ»Áлò¶à¸öÁÐÉϵĸ¨Öú¶ÔÏó£¬Ä¿µÄÊǼӿì·ÃÎʱíÖеÄÊý¾Ý£»
¡¡¡¡
¡¡¡¡Oracle´æ´¢Ë÷ÒýµÄÊý¾Ý½á¹¹ÊÇB*Ê÷£¬Î»Í¼Ë÷ÒýÒ²ÊÇÈç´Ë£¬Ö»²»¹ýÊÇÒ¶×ӽڵ㲻ͬB*ÊýË÷Òý£»
¡¡¡¡
¡¡¡¡Ë÷ÒýÓɸù½Úµã¡¢·ÖÖ§½ÚµãºÍÒ¶×Ó½Úµã×é³É£¬Éϼ¶Ë÷Òý¿é°üº¬Ï¼¶Ë÷Òý¿éµÄË÷ÒýÊý¾Ý£¬Ò¶½Úµã°üº¬Ë÷ÒýÊý¾ÝºÍÈ·¶¨ÐÐ ......
Õª Òª£º±¾ÎÄÌÖÂÛÁËOracleºÍSQL ServerµÄÔÚÊÂÎñ´¦ÀíÉϵÄÇø±ð£¬²¢·ÖÎöÁËÆäʵÏÖ»úÖÆµÄ²îÒì¡£
¹Ø¼ü´Ê£ºOracle£»SQL Server£»ÊÂÎñ£»ÊÂÎñ¸ôÀë¼¶±ð£»DDL¡£
ÊÂÎñ´¦ÀíÊÇËùÓдóÐÍÊý¾Ý¿â²úÆ·µÄÒ»¸ö¹Ø¼üÎÊÌ⣬¸÷Êý¾Ý¿â³§É̶¼ÔÚÕâ¸ö·½Ã滨·ÑÁ˺ܴó¾«Á¦£¬²»Í¬µÄÊÂÎñ´¦Àí·½Ê½»áµ¼ÖÂÊý¾Ý¿âÐÔÄܺ͹¦ÄÜÉϵľ޴ó²îÒì¡£
ÊÂÎñ´¦ÀíÒ²ÊÇÊý¾Ý¿â¹Ü ......