RE: Load Balancing
- From: "Vasu Balla" <appsdba@xxxxxxxxx>
- To: <Oliver.Jost@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Oct 2008 10:06:13 +0200
Hi Oliver,
here is a trick that i would try
Disable all listener level loadbalcing by commenting out remote_listener
init ora param
on both db servers and change the tns names on the middleter forms/reports
servers as follows
-- for 1:1 load balancing
PROD=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=PROD)
)
)
-- for 2:1 load balancing
PROD=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=PROD)
)
)
-- for 3:2 load balancing
PROD=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=server2-vip)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=PROD)
)
)
Vasu Balla
Apps DBA - The Pythian Group
www.pythian.com
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Oliver Jost
Sent: Wednesday, October 08, 2008 5:46 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Load Balancing
Hi All,
If anyone could shed some light I'd appreciate it... I have a 2-node
(10gR2/Solaris 9) cluster in which one node has weaker cpu (both have 12
cpu, stronger has 8xUltraSPARC IV+ [1.5 GHz] while the weaker has
8xUltraSPARC IV [1.2 GHz]). The load balancing was favouring the weaker
node (e.g. higher active sessions, higher load, new sessions connecting
while the stronger node putters along). The sessions have a relatively even
spread, however, due to capacity the weaker node is the bottleneck. I'd
like to balance server-side but am running into difficulties. Oracle docs
state OCI release 2 is required for server-side to work. I believe our
middle tier is running an up to date OAS 10.1.2.0.2 (forms/reports,
Solaris10). I'm not clear on the middle tier but I believe it uses release
1 for OCI. I'd like to configure the listener to balance by load (I have
not been successful in our test environment, working with Oracle on bug or
middle tier issues, not resolved yet) so when the weaker server experiences
a higher load new connections go to the more powerful server rather than
just load balance client-side (2 nodes, 50/50). I do have some options via
the middle tier and/or services. The ideal would be minimize configuration
changes while maintaining HA.
Any suggestions (hints, tips, pointers to docs) are welcome.
Thanks,
Oliver
Other related posts:
