Load balancing between an RAC database cluster and Top Link

Giganews Newsgroups
Subject: Load balancing between an RAC database cluster and Top Link
Posted by:  gcolle…@reserveamerica.com
Date: 26 Jan 2004

All,

We are designing an environment which is comprised of 3 database
servers clustered together using RAC 10g. Connecting to the database
is an Oracle Application Cluster of 4 App Servers running toplink.
Currently the connection is facilitated through XML using oracle jdbc
drivers.

My question: In order to properly load balance the calls to the
databse servers, do I require a hardware level load balancer between
the Application tier and the Database tier?

My understanding is that Oracle chares the db cache between the 3
servers, and I believe it does load balancing between the servers as
well. However, the jdbc connection on the app servers currently points
at 1 database machine directly, and if that machine went down, the app
could not connect to the RAC cluster (without a manual change). Is
there a non-hardware solution to get around this?

I am new to some of this and would appreciate any guidance.

Thanks,
Greg

Replies