What is the best way to do Oracle load balancing? I
see many choices with Oracle failover, but for load
balancing, I was taught that a more intelligent approach is
best for load balancing.
Oracle weblogic and webserver
promotes a load balancing algorithm based on a round-robin
or a least-recently-loaded method. However, this is
not the "best" load balancing strategy for RAC databases.
In RAC, you can avoid cache fusion overhead by load
balancing like-minded transactions to the same nodes.
For example, the load balancer would direct customer
requests to a customer node and product-oriented requests to
a product node.
This type of load balancing is easy because Oracle clients
will have different tnsnames.ora files, which direct the
connections to the "best" node to have the cached data that
the client uses.
This load balancing greatly reduces inter-node
communications and ensures better caching of Oracle
information. For more information on load balancing,
see these related links: