Discussion:
Load Balancing Oracle Apex Application on Apache tomcat.
chandra sekhar
2016-07-06 16:08:06 UTC
Permalink
Hi,

We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5 Application
on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64 GNU/Linux).

As we have around 300-500 users using this application,we would like to
know if we can load balance our Oracle Apex Application on 2 or 3 frontend
servers to distribute the load.Hence,kindly help me how to configure load
balance on Apache tomcat.

I'm open to tips and advices ;)

Thanks,
Chandra
Abhijit Das
2016-07-06 16:10:39 UTC
Permalink
Do you have the option to offload load balancing to a different server? If so, look at haproxy and/or nginx. haproxy would be more customizable. If there are bandwidth constraints, implement a DSR VIP (IP triangulation).


On Jul 6, 2016, at 9:08 AM, chandra sekhar <***@gmail.com> wrote:

Hi,

We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5 Application
on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64 GNU/Linux).

As we have around 300-500 users using this application,we would like to
know if we can load balance our Oracle Apex Application on 2 or 3 frontend
servers to distribute the load.Hence,kindly help me how to configure load
balance on Apache tomcat.

I'm open to tips and advices ;)

Thanks,
Chandra


---------------------------------------------------------------------
To unsubscribe, e-mail: users-***@tomcat.apache.org
For additional commands, e-mail: users-***@tomcat.apache.org
chandra sekhar
2016-07-06 16:41:16 UTC
Permalink
Yes.we have an option to offload load balancing to a different server.Could
you please explain more on haproxy if you can and please share me doc
related to this and load balancing?
Post by Abhijit Das
Do you have the option to offload load balancing to a different server? If
so, look at haproxy and/or nginx. haproxy would be more customizable. If
there are bandwidth constraints, implement a DSR VIP (IP triangulation).
Hi,
We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5 Application
on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64 GNU/Linux).
As we have around 300-500 users using this application,we would like to
know if we can load balance our Oracle Apex Application on 2 or 3 frontend
servers to distribute the load.Hence,kindly help me how to configure load
balance on Apache tomcat.
I'm open to tips and advices ;)
Thanks,
Chandra
---------------------------------------------------------------------
Abhijit Das
2016-07-06 16:45:45 UTC
Permalink
start here — http://www.haproxy.org/#desc <http://www.haproxy.org/#desc>

And, then search on internet, lots and lots of examples configuring haproxy with tomcat as backend. you could SSL client offload (need TPROXY enabled), etc etc.



On Jul 6, 2016, at 9:41 AM, chandra sekhar <***@gmail.com> wrote:

Yes.we have an option to offload load balancing to a different server.Could
you please explain more on haproxy if you can and please share me doc
related to this and load balancing?
Post by Abhijit Das
Do you have the option to offload load balancing to a different server? If
so, look at haproxy and/or nginx. haproxy would be more customizable. If
there are bandwidth constraints, implement a DSR VIP (IP triangulation).
Hi,
We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5 Application
on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64 GNU/Linux).
As we have around 300-500 users using this application,we would like to
know if we can load balance our Oracle Apex Application on 2 or 3 frontend
servers to distribute the load.Hence,kindly help me how to configure load
balance on Apache tomcat.
I'm open to tips and advices ;)
Thanks,
Chandra
---------------------------------------------------------------------
chandra sekhar
2016-07-06 16:56:01 UTC
Permalink
Thanks for the info Abhijit,

Let me go through these links and will get back to you if need any help.
Post by Abhijit Das
start here — http://www.haproxy.org/#desc <http://www.haproxy.org/#desc>
And, then search on internet, lots and lots of examples configuring
haproxy with tomcat as backend. you could SSL client offload (need TPROXY
enabled), etc etc.
Yes.we have an option to offload load balancing to a different server.Could
you please explain more on haproxy if you can and please share me doc
related to this and load balancing?
Post by Abhijit Das
Do you have the option to offload load balancing to a different server?
If
Post by Abhijit Das
so, look at haproxy and/or nginx. haproxy would be more customizable. If
there are bandwidth constraints, implement a DSR VIP (IP triangulation).
Hi,
We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5 Application
on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64 GNU/Linux).
As we have around 300-500 users using this application,we would like to
know if we can load balance our Oracle Apex Application on 2 or 3
frontend
Post by Abhijit Das
servers to distribute the load.Hence,kindly help me how to configure load
balance on Apache tomcat.
I'm open to tips and advices ;)
Thanks,
Chandra
---------------------------------------------------------------------
Christopher Schultz
2016-07-06 20:05:28 UTC
Permalink
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Chandra,
Post by chandra sekhar
We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5
Application on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64
GNU/Linux).
As we have around 300-500 users using this application,we would
like to know if we can load balance our Oracle Apex Application on
2 or 3 frontend servers to distribute the load.Hence,kindly help me
how to configure load balance on Apache tomcat.
I'm open to tips and advices ;)
We need more requirements to actually help. For example, I have no
clue what Oracle Apex is. Does it use sessions? Are they
distributable? Do you just want load-balancing, or do you need
seamless-failover?

- -chris
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJXfWSIAAoJEBzwKT+lPKRYZq8P/iU7fUMmDT3/9UEFy2jazLZy
D0EhDJjhrzaAjQQCUL2Ywl6XkmS0EnaxU2pySoWoG+mzI1mrBNiGP+RvmUoOLGZc
wjx+e56z7P2UTNl+6k+Q7qjEodqlWe6XTB9RrLg8ecXqHa/1TY5dWR0Jg7HylK7m
OYiIQ0iygkyhcquAxmeCqqQNN5ByhXtIE5uHXMJgzQeELj2RwQ+AiX8nPYYb7Yq4
JvPjun/RHgRT3zUEByflCdGvdedesItKjvACvVCwGQMzSgRYlqtzvisP0oi0il5R
tFvePF/6knlAlFSLtAG4Uy5dWpOnouHznAra8Ud9MsXFHI695I8+7xSE+7dx/cUd
ipLGk9JpZyDyuwJ1tpThMjBmBTtnPDNSs7GHZAcsFtzhButvnZOwO4kz64aNk7Yt
Dwsw3H939KITr0yCffcc7TZ6V0vOLJl12MANX2xxsKejbhSO+VAyC27JpRFivUQL
lidJrXk50g3Ka2v3nUDE/cmOLzYO6ibwEwXs3zqzt2S1w390A/8igwhiLR/+nc+4
xCTUyZBRcPZ7sC9DSCqiztfChoRIYc8IOXE0BE8NyoOJl1SWSO/L6LjElX3UtF4O
UpohbzbFHVigfsjaHM3NXhMkNsLfVN2n0/tE1GZQ7rBvmPlGfknwB/t0hWFw98Av
1xw98gTVREZwumaCFnsg
=QW1U
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-***@tomcat.apache.org
For additional commands, e-mail: users-***@tomcat.apache.org
chandra sekhar
2016-07-06 21:34:24 UTC
Permalink
Hi Christopher,

Oracle Apex is a web application to build a web based application.It will
retrieves the static file content from DB by executing stored procedures
etc.Hence,for this it creates sessions in the DB as well.Session can be
distributed.So we are thinking to load balance.Please advice.

Thanks,
Chandra

On Wed, Jul 6, 2016 at 4:05 PM, Christopher Schultz <
Post by Christopher Schultz
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Chandra,
Post by chandra sekhar
We were using apache-tomcat-7.0.55 for our Oracle Apex 4.2.5
Application on Linux(Linux 2.6.32-573.22.1.el6.x86_64 x86_64
GNU/Linux).
As we have around 300-500 users using this application,we would
like to know if we can load balance our Oracle Apex Application on
2 or 3 frontend servers to distribute the load.Hence,kindly help me
how to configure load balance on Apache tomcat.
I'm open to tips and advices ;)
We need more requirements to actually help. For example, I have no
clue what Oracle Apex is. Does it use sessions? Are they
distributable? Do you just want load-balancing, or do you need
seamless-failover?
- -chris
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCAAGBQJXfWSIAAoJEBzwKT+lPKRYZq8P/iU7fUMmDT3/9UEFy2jazLZy
D0EhDJjhrzaAjQQCUL2Ywl6XkmS0EnaxU2pySoWoG+mzI1mrBNiGP+RvmUoOLGZc
wjx+e56z7P2UTNl+6k+Q7qjEodqlWe6XTB9RrLg8ecXqHa/1TY5dWR0Jg7HylK7m
OYiIQ0iygkyhcquAxmeCqqQNN5ByhXtIE5uHXMJgzQeELj2RwQ+AiX8nPYYb7Yq4
JvPjun/RHgRT3zUEByflCdGvdedesItKjvACvVCwGQMzSgRYlqtzvisP0oi0il5R
tFvePF/6knlAlFSLtAG4Uy5dWpOnouHznAra8Ud9MsXFHI695I8+7xSE+7dx/cUd
ipLGk9JpZyDyuwJ1tpThMjBmBTtnPDNSs7GHZAcsFtzhButvnZOwO4kz64aNk7Yt
Dwsw3H939KITr0yCffcc7TZ6V0vOLJl12MANX2xxsKejbhSO+VAyC27JpRFivUQL
lidJrXk50g3Ka2v3nUDE/cmOLzYO6ibwEwXs3zqzt2S1w390A/8igwhiLR/+nc+4
xCTUyZBRcPZ7sC9DSCqiztfChoRIYc8IOXE0BE8NyoOJl1SWSO/L6LjElX3UtF4O
UpohbzbFHVigfsjaHM3NXhMkNsLfVN2n0/tE1GZQ7rBvmPlGfknwB/t0hWFw98Av
1xw98gTVREZwumaCFnsg
=QW1U
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Christopher Schultz
2016-07-06 21:45:07 UTC
Permalink
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Chandra,
Post by chandra sekhar
Oracle Apex is a web application to build a web based
application.It will retrieves the static file content from DB by
executing stored procedures etc.Hence,for this it creates sessions
in the DB as well.Session can be distributed.So we are thinking to
load balance.Please advice.
Tomcat is happy to live behind any kind of reverse proxy. If you want
to use sticky sessions (usually a good idea), you'll want to make the
reverse proxy aware of the JSESSIONID session cookie and/or the
jsessionid path parameter to provide sticky-session-handling.

If you use Apache httpd + mod_jk, you get some configuration-less
configuration for free such as TLS information being forwarded
automatically to the Tomcat node.

If you want to use HTTP as your proxying protocol, then you'll have to
arrange for the various data to be packed-into HTTP headers to be sent
to Tomcat. You can use Tomcat's RemoteIPValve to consume those HTTP
headers to provide the reverse proxy's connection information to
Tomcat (and thus, your web application).

Members of this list have experience with all kinds of reverse-proxy
servers. My deepest experience is with httpd+mod_jk+Tomcat while
others may use httpd+mod_proxy_http+Tomcat or nginx+Tomcat or
haproxy+Tomcat or squid+Tomcat. Or even IIS + Tomcat if necessary.

Apache httpd is a fairly heavy web server to use if all you want to do
is load-balancing and proxying. If there is another reason to use
httpd then by all means use it.

I would say you should check to see who will be supporting the
load-balancer and ask them what their preference is. It's far more
important to make sure the load-balancer is maintained properly than
to pick one based solely upon the recommendations of the members of
this mailing list.

Hope that helps,
- -chris
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJXfXvjAAoJEBzwKT+lPKRYlG0P/2Ng5ruyCxSqRg1Sqp6wYKqT
i79Pw12xzi0oCN3ekJtPvZDGF5hd2YRjorhCljKbt2yBWw2wMhJE159TMI5T3wvB
8P88dpGLDDLAWxgxT2YaRzlpCYYBQyTwQ/vYboA1UjJuLqE4jj9z7xlvwS0w7yeL
3aWsYyxRcCTu2NGv+VT0ayib2C4iqYkJGD2gqHp7hsN91fqb69/fRJtvhy5Ix4W1
U9cvGrwo8MfBzJ4/8KDE+DbWxBLX9bo3hkzo9Uaavb9rhlcMJIaP8iQv2/GP7qID
yc0geI5rUmkLp0nIb+REzmGAAki/mWDyYp+YHQz9N05kqUKj352ffY01L823RLHd
2lNosx8xuOu94NbnVq8QGM/B55AKdB4hx+ShhzwfA8MJocaLv79odaQG3JrE99i/
xsQ0LZOhxlwVJjGJtsEP6cdjx6vgAjyOXqvlu1/On0mECz7FNFpCYUTpTkb78F5p
vxNQe1a2PRXIFhPl4mXRIXMlCyDhXn5cja81V5oqhuOT5rb2D+PT3z+0xar0YgXy
/xdyBebKVH/0ndE9KDIqz2Yqf0QVq+WKiQqQA6TNYB5NKg1NpyBzCoYk110H8uyx
bLYVJWaNZGrwoqmrkl1VAPK6Eu4DD+RhtSmosAiHerJ7BDtB7q1mq7iLk2qoaTrr
M4eOM5j8IWyh9vhJEfUw
=sFyG
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-***@tomcat.apache.org
For additional commands, e-mail: users-***@tomcat.apache.org

Loading...