首页 > Linux操作系统 > Linux操作系统 > RAC中LB实现


原创 Linux操作系统 作者:xuelu2000 时间:2013-06-23 20:25:57 0 删除 编辑
1、Connection Balancing(技术解决方案)

Oracle Net waits for 10 seconds to receive a response, after which it assumes a failure. Oracle Net goes through the address list three times before it returns a failure to the client.



提出了一个Load Balancing Advisory、Load Balancing Advisory FAN Events概念。配置完毕Advisory后,数据库会向客户端发布响应的FAN Events,客户端再根据接受到Events进行自定义处理。这部分内容,目前只了解了一些概念,后续再进行细化。
Load Balancing Advisory
By using the Load Balancing Advisory or runtime connection load balancing goals, feedback is built in to the system.
You can configure your environment to use the load balancing advisory by defining service-level goals for each service for which you want to enable load balancing. Configuring a service-level goal enables the load balancing advisory and the publishing of FAN load balancing events for that service.
There are two types of service-level goals for runtime connection load balancing:
■ SERVICE_TIME: Attempts to direct work requests to instances according to response time. Load balancing advisory data is based on elapsed time for work done in the service plus available bandwidth to the service.
#srvctl modify service -d db_unique_name -s online -B SERVICE_TIME -j SHORT
■ THROUGHPUT: Attempts to direct work requests according to throughput. The load balancing advisory is based on the rate that work is completed in the service plus available bandwidth to the service.
#srvctl modify service -d db_unique_name -s sjob -B THROUGHPUT -j LONG

Setting the runtime connection load balancing goal to NONE disables load balancing for the service. You can see the goal settings for a service in the data dictionary by querying the DBA_SERVICES, V$SERVICES, and V$ACTIVE_SERVICES views. You
can also review the load balancing settings for a service using Oracle Enterprise Manager.

Load Balancing Advisory FAN Events
The load balancing advisory FAN events provide metrics for load balancing algorithms. The easiest way to take advantage of these events is to use the runtime connection load balancing feature of an Oracle integrated client such as JDBC,ODP.NET, or Oracle Call Interface. Other client applications can take advantage of FAN programatically by using the Oracle Notification Service application programming interface (ONS API) to subscribe to FAN events and execute event-handling actions upon receipt.

Oracle Clients That Are Integrated with Fast Application Notification
Oracle has integrated FAN with many of the common client application environments that are used to connect to Oracle RAC databases. Therefore, the easiest way to use FAN is to use an integrated Oracle Client.

Enabling JDBC Clients for Fast Connection Failover

Enabling JDBC Clients for Runtime Connection Load Balancing
Runtime connection load balancing requires that FCF is enabled and configured properly.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: RAC中Failover实现


  • 博文量
  • 访问量