Re: Database Load Balancing?

First it seems they have it backwards. Your sysadmins gave you a solution to implement (design) instead of a problem to solve (requirements). Are they looking for increased capacity, improved up time, or something else?

Here is one approach that gives you increased capacity and better availability. Install Oracle Parallel Server (OPS) on two boxes that have shared disk arrays (maybe using Fiber Channel). Then either box can get to any disk. Of course the disks should probably be in a RAID 0+1 configuration. Oracle 8i OPS is supposed to support "load balancing", but we have not used it.

You can do manual load balancing, by settnig up your app to always access 1/2 of your tables through server 1, and the other half of the tables through server 2. I have been told OPS does better when both machines are not both accessing the same tables.

Good Luck,
Brian Beuning

Van Messner wrote:

> The sysadmins told me they'd like a setup where multiple
> copies of an identical database would be accessed depending on
> which copy currently had the lightest load.
> I've heard of load balancing on application servers but not on
> multiple database servers. Neither replication nor parallel
> server would seem to provide what the sysadmins want.
> Does Oracle have a multiple database solution such as they
> describe?
>
> Van
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
Received on Sat Jul 15 2000 - 00:00:00 CDT