Load Balancing Data Relationship Management Web Applications

You can configure Oracle HTTP Server to provide load balancing support to two or more Data Relationship Management Web applications. You set up Oracle HTTP Server to redirect requests to the IIS servers hosting the Data Relationship Management Web client. This procedure assumes that the Oracle HTTP Server installed by the EPM System Installer is the logical host. The EPM System Installer performs the necessary prerequisite checks for Oracle HTTP Server. For more information, see “Oracle HTTP Server Installation Prerequisites” in the Oracle Hyperion Enterprise Performance Management Installation and Configuration Guide.

  To set up Oracle HTTP Server as a load balancer for the Data Relationship Management Web client:

  1. Install the Data Relationship Management Web Server component on two or more computers running IIS.

  2. Configure Data Relationship Management applications and host computers using the procedure described in UI Web Servers.

  3. Open the httpd.conf file for Oracle HTTP Server found in the following location:

    MIDDLEWARE_HOME/user_projects/epmsystem1/httpConfig/ohs/config/OHS/ohs_component/httpd.conf

  4. Ensure that the following directives exist and are enabled. Add the directives if they do not exist.

    LoadModule proxy_balancer_module “${ORACLE_HOME}/ohs/modules/mod_proxy_balancer.so”

    LoadModule headers_module “${ORACLE_HOME}/ohs/modules/mod_headers.so”

  5. Create a proxy balancer definition for the Data Relationship Management Web client by adding a BalanceMember directive for each IIS server that hosts the Data Relationship Management Web Server component.

    #Configure members for cluster
<Proxy balancer://iisdrm>
  	BalancerMember http://Machine1:80/drm-web-client route=server1
  	BalancerMember http://Machine2:80/drm-web-client route=server2  
</Proxy>

  6. Enable sticky load balancing by adding the following directives. These sample directives instruct Oracle HTTP Server to insert a cookie that keeps track of the route for sticky load balancing of the proxy balancers defined in the previous step.

    Header add Set-Cookie "BALANCEID= iisdrm.%{BALANCER_WORKER_ROUTE}; path=/drm-web-client;" env=BALANCER_ROUTE_CHANGED

  7. Add the following Forward and Reverse Proxy directives.

    #The actual ProxyPass
ProxyPass /drm-web-client balancer://iisdrm stickysession=BALANCEID nofailover=Off

#Do not forget ProxyPassReverse for redirects
ProxyPassReverse /drm-web-client http://<drm_web_server1>:80/drm-web-client
ProxyPassReverse /drm-web-client http://<drm_web_server2>:80/drm-web-client

  8. Save the httpd.conf file and restart the Oracle Process Manager server for the Oracle HTTP Server instance.

    After configuration, the Data Relationship Management web application can be accessed using the following URL: http://<ohs_server>:<port>/drm-web-client.