Re: CAN YOU TO CHECK THE LOAD_BALANCER CONFIGURATION ON RAC SERVER
Date: Tue, 26 Feb 2008 00:55:42 -0800 (PST)
Further to Finn's point:
- the load balancer attempts to allocate new connections to the "least loaded"
- however, the measurement of "load" on each node is not very subtle, and it
takes a while for the listener to be updated with it
- which means that if you have a rush of connections, they may ALL go to the
currently least loaded node (or if all nodes are the same, the first node in the listener's list).
- Giving you a very unbalanced load (which will never be corrected until more
connections are made).
A very common "connection storm" is when starting up an app server; I found
that a load-balanced (9i) OC4J would routinely set up all its initial
connections on the same node. A similar situation and a workaround is mentioned
Of course, if any of your connections terminate (for example, if your connection pool shrinks itself), you can also see a balanced load become unbalanced.
Regards NigelReceived on Tue Feb 26 2008 - 02:55:42 CST