Re: Need a solution for E-Business Loadbalancing without additional hardware

  • From: "Priyank Jain" <mail2priyank@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Thu, 29 May 2008 16:55:45 +0100

Hi All,

I think it is possible to setup the load-balancing as well as High
availablilty on Linux platforms.

Today, I installed IPVS and Heartbeat packages for Linux and gone through
100s of articles on internet to finally implement load balancing via Redhat
software itself. This is something called as Linux Virtual Server
implementation that uses common Virtual IP address as single access-point to
the Applications.

So effectively, I'll be using only 2 nodes and no additional hardware to
implement load balancing for internet (external) users of Oracle Apps.

On most articles, they mentioned a use of separate server (or 2 of them) to
act as Director and route the requests to one of the real servers, but I
modified the approach for my case and I'm using the same servers as
Director, internally routing the request to the real servers amongst
themselves. Also, I verified the failover works just fine with heartbeat
functionality in place.

So far it looks good. Will see what more roadblocks come in as I move
further.

Thanks for all the inputs so far and keep sharing.

Cheers,
Priyank.

On Thu, May 29, 2008 at 2:54 AM, Pravin RC <pravinrc@xxxxxxxxx> wrote:

> Hi Priyank,
>
> Could you please write me the architecture ? I have implemented DMZ Oracle
> 12 with 2 external and 2 internal servers, with Big5 LB.
>
> thanks
>
> Pravin
>
> On Wed, May 28, 2008 at 5:18 PM, Priyank Jain <mail2priyank@xxxxxxxxx>
> wrote:
>
>> Hi Atul,
>>
>> Thanks for the response.
>> I understand that this is not certified, but given the situation, I need
>> to take this up as a challenge.
>> I have gone down to the OS level to get a resolution to this. One option
>> is using Heartbeat package shipped for Linux.
>> I'm also investigating using the IPVS service distributed with the RHEL to
>> get around the issue of maintaining session data such as cookie to ensure
>> that the client always connects to the same server.
>> Will keep you all posted on any developments. Any help on this subject is
>> much solicited.
>>
>> Thanks,
>> Priyank.
>>
>>
>> On Tue, May 27, 2008 at 7:31 PM, Atul Kumar <atul_iiit@xxxxxxxxx> wrote:
>>
>>> Priyank,
>>>  Software load balancer is not supported/certified in front of Oracle
>>> Apps 11i/R12 as it can't maintain session persistence (It is requirement in
>>> apps that request from one client always connect to same server till user
>>> session logout )
>>>
>>>
>>> http://onlineappsdba.com/index.php/2006/12/20/oracle-apps-load-balancer-setup-for-http-server/
>>>
>>>
>>>
>>> Atul Kumar
>>> +44-7525173921
>>> http://teachmeoracle.com/forum
>>>
>>>
>>>
>>> --- On Tue, 5/27/08, Priyank Jain <mail2priyank@xxxxxxxxx> wrote:
>>>
>>> > From: Priyank Jain <mail2priyank@xxxxxxxxx>
>>> > Subject: Need a solution for E-Business Loadbalancing without
>>> additional hardware
>>> > To: ora-apps-dba@xxxxxxxxxxxxx
>>> > Date: Tuesday, May 27, 2008, 6:26 PM
>>>  > Hi Guys,
>>> >
>>> > need some help with Oracle Apps load balancing issue.
>>> >
>>> > *Here is the detailed issue:*
>>> >
>>> > We want to implement 2 DMZ (external) nodes on E-Business
>>> > suite for external
>>> > customers using istore and configurator modules.
>>> > I have already created the DMZ servers and they are working
>>> > perfectly with
>>> > their own hostnames.
>>> >
>>> > I want to do load-balancing on these 2 nodes so that the
>>> > network traffic can
>>> > be distributed evenly between the two. Also, one of them
>>> > can act as a
>>> > failover.
>>> > I have checked all Advanced topologies but couldnt find any
>>> > that can work
>>> > for internet users and uses no hardware to do the
>>> > load-balancing.
>>> >
>>> > Can anyone suggest some software load-balancing technique
>>> > to resolve my
>>> > issue.
>>> >
>>> >
>>> > Thanks,
>>> > Priyank.
>>>
>>>
>>
>
>
> --
> Affectionately Yours
> Pravin R C

Other related posts: