RAC负载均衡和失效接管.pptx

Load Balancing Failover (RAC)RAC负载均衡和失效接管About ACOUGACOUG: All China Oracle User GroupAbout MeKamus/Oracle - Enmou与技术无关将技术作为艺术对待以兴奋的状态面对知识Load Balancing负载均衡Load BalancingClient-side Load BalancingConnection Balancing = client-side connect-time LBServer-side Load BalancingListener Balacing = server-side connect-time LBRuntime Service Balancing = runtime connection load balancingClient-side Load BalancingTNSNAMES.ORA : RACDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip3)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVICE_NAME = racdb) ) )Client-side Load BalancingnetmgrServer-side Load BalancingListener (Connection) BalancingOracle9i and HigherService BalancingOnly on Oracle10gR2 and HigherListener Balancingsql ALTER system SET REMOTE_LISTENER=LISTENERS_RAC scope=BOTH;TNSNAMES.ORA :LISTENERS_RAC =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = vip3)(PORT = 1521)))Listener BalancingListener BalancingListener LogOracle10g: $ORACLE_HOME/logOracle11g: diagnostic_dest/diag/tnslsnr/hostname/listener/traceService Register18-11月-2009 11:54:07 * service_register * orcl11g * 0Service Update18-11月-2009 11:54:13 * service_update * orcl11g * 0Listener BalancingV$SERVICEMETRICGOODNESSDELTALoad Based Session BasedPREFER_LEAST_LOADED_NODE_Undocumented parameter on Oracle and higherDefaults to “ON”PREFER_LEAST_LOADED_NODE_LISTENER_NAME=OFFLISTENER_NAME = listener_nodenameAfter 10gR2, set the CLB_GOAL on the serviceService Balancingsrvctl add service -d orcl -s orclcluster -r orcl1,orcl2 -a orcl3,orcl4Powerful automatic workload managementDefine PREFERRED instancesDefine AVAILABLE instancesRuntime load balancingOpposite to Connect time load balancingService StatisticsFast Application Notification (FAN)Fast Connection Failover(