RE: [load balancing] (alteon) - Web Servers to Database issue

From: Adilson Lemos (adilsonlIZZATcorp.globo.com)
Date: Fri Jul 02 2004 - 15:48:55 EDT


Vitor,
 
has each webserver tns file that point to the same database server ?
 
If yes there are two main points.
 
First - NAT. We had already problems to access Database through NAT Process.
Please try to simulate the same situation without NAT process if you can.
Second - I don know what kind of you FW, but follow below one clue about it.
 
http://www.firetower.com/faqs/search-msgs/2001/06/02-006.html
<http://www.firetower.com/faqs/search-msgs/2001/06/02-006.html>
 
And About NAT, are you doing also source nat or just destination nat ?
 
Adilson Lemos.
 
 
 

-----Original Message-----
From: Jose Vitor Barreiro [mailto:Vitor.BarreiroIZZATcompta.pt]
Sent: Thursday, July 01, 2004 10:32 AM
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Hi,
Software Version 21.0.4
 

Vitor Barreiro

  _____

From: Hasan Dilmaç [mailto:hasanIZZATprolink.com.tr]
Sent: quinta-feira, 1 de Julho de 2004 11:51
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Hi Vitor,
What is the software version of 2424 ssl ?
 
-Hasan

-----Original Message-----
From: owner-lb-lIZZATvegan.net [mailto:owner-lb-lIZZATvegan.net] On Behalf Of Jose
Vitor Barreiro
Sent: Wednesday, June 30, 2004 12:05 PM
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Hi,
 
I`m going to try to answer your questions:
- In the alteon, for that two web servers i only have a VIP with HTTP
service. The comunication between the WebServers and Database Server
(Oracle) are only L2 and L3, and individually.
For exemple: There are a HTTP request from a client to one of the WebServer
and When the WebServer needs some data from the DatabaseServer (DBServer),
it established a connection using the TCP port 1521 (TNS protocol) to get
that data information. The WebServer ip address 192.168.1.5 tries to connect
with DBServer 192.168.1.9 in the DMZ, and the firewall translate that
address (NAT) to the real ip address 10.0.10.30 of the (DBServer). This
works fine when i only have one WebServer doing that request to the
DBserver, because when i have the two WebServers requesting information from
the WebServer 5% of the times the connections fails.

 

 

Vitor Barreiro

 

  _____

From: Adilson Lemos [mailto:adilsonlIZZATcorp.globo.com]
Sent: terça-feira, 29 de Junho de 2004 18:12
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Vitor,
 
Well, some questions:
 
1 - both webservers can connect to database ? If you enter in the each web
server and execute telnet to database on the port 1521 you have success ?
2 - Based on the question above, through telnet and client access to
webservers the request from webservers are being to database with some ip
address of the source or not ?
3 - Are you receiving any type of error from Database ? if yes which will be
?
 
Adilson Lemos.
 

-----Original Message-----
From: Jose Vitor Barreiro [mailto:Vitor.BarreiroIZZATcompta.pt]
Sent: Tuesday, June 29, 2004 11:25 AM
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Hi Adilson,
 
I configured the hash metric and I still have the same issue.
The Web Servers and the database server use the TNS - Transparent Network
Substrate Protocol to communicate between them.
I don´t known if this can help you, helping me to find the source of the
problem and the solution?
 
 

Vitor Barreiro

  _____

From: Adilson Lemos [mailto:adilsonlIZZATcorp.globo.com]
Sent: terça-feira, 29 de Junho de 2004 6:18
To: lb-lIZZATvegan.net
Subject: RE: [load balancing] (alteon) - Web Servers to Database issue

Vitor,
 
One way would be configuring hash metric for the group.
 
Adilson Lemos.

-----Original Message-----
From: Jose Vitor Barreiro [mailto:Vitor.BarreiroIZZATcompta.pt]
Sent: Tuesday, June 22, 2004 5:46 AM
To: lb-lIZZATvegan.net
Subject: [load balancing] (alteon) - Web Servers to Database issue

Hi
 
 
I have a alteon AA2424SSL balancing some Web Servers. One of the groups have
two Web Servers. That Web Servers are in the DMZ and they need to pick up
some data(text, pictures, etc) from one database server in the LAN. With
only one server working in the group everything since to work ok, but with
the two web servers active some times some of the connections between the
Web Servers and the Database Server fails. Anyone have a clue of what could
be the cause of this.
 
 
Simple diagram of the network:
 
Client ------>FW--------AAS2424SSL --------------Web1
                   ! !---------------Web2
            SW Core
                   !
                   !
             Database
               Server
 
 
Regards
 
 

Vitor Barreiro

 

***************************************************************************
Este email assim como os ficheiros que possa ter em anexo sao confidenciais
e para uso exclusivo da pessoa ou organizacao para o qual foi enviado. Se
recebeu esta mensagem por engano por favor notifique a Compta atraves do
endereco postmasterIZZATcompta.pt

Esta mensagem foi verificada pelo sistema MAILsweeper nao tendo sido
encontrados virus. http://www.mimesweeper.com

MAILsweeper - Modulo da suite MIMEsweeper, solucao de filtragem de conteudos
comercializada pela Compta SA.

A Compta SA detem o mais alto nivel de especializacao MIMEsweeper, tendo
sido reconhecida pela Clearswift como Premier Partner.
***************************************************************************
This message is confidential and may contain privileged information intended
solely for the named addressee(s). It may not be used or disclosed except
for the purpose for which it has been sent.

If you are not the intended recipient, you must not copy, distribute or take
any action in reliance on it. If you have received this message in error,
please notify Compta by emailing postmasterIZZATcompta.pt quoting the sender and
delete the message and any attached documents.

This footnote confirms that this email message has been swept by MIMEsweeper
for Content Security threats, including computer viruses
***************************************************************************

***************************************************************************
Este email assim como os ficheiros que possa ter em anexo sao confidenciais
e para uso exclusivo da pessoa ou organizacao para o qual foi enviado. Se
recebeu esta mensagem por engano por favor notifique a Compta atraves do
endereco postmasterIZZATcompta.pt

Esta mensagem foi verificada pelo sistema MAILsweeper nao tendo sido
encontrados virus. http://www.mimesweeper.com

MAILsweeper - Modulo da suite MIMEsweeper, solucao de filtragem de conteudos
comercializada pela Compta SA.

A Compta SA detem o mais alto nivel de especializacao MIMEsweeper, tendo
sido reconhecida pela Clearswift como Premier Partner.
***************************************************************************
This message is confidential and may contain privileged information intended
solely for the named addressee(s). It may not be used or disclosed except
for the purpose for which it has been sent.

If you are not the intended recipient, you must not copy, distribute or take
any action in reliance on it. If you have received this message in error,
please notify Compta by emailing postmasterIZZATcompta.pt quoting the sender and
delete the message and any attached documents.

This footnote confirms that this email message has been swept by MIMEsweeper
for Content Security threats, including computer viruses
***************************************************************************

***************************************************************************
Este email assim como os ficheiros que possa ter em anexo sao confidenciais
e para uso exclusivo da pessoa ou organizacao para o qual foi enviado. Se
recebeu esta mensagem por engano por favor notifique a Compta atraves do
endereco postmasterIZZATcompta.pt

Esta mensagem foi verificada pelo sistema MAILsweeper nao tendo sido
encontrados virus. http://www.mimesweeper.com

MAILsweeper - Modulo da suite MIMEsweeper, solucao de filtragem de conteudos
comercializada pela Compta SA.

A Compta SA detem o mais alto nivel de especializacao MIMEsweeper, tendo
sido reconhecida pela Clearswift como Premier Partner.
***************************************************************************
This message is confidential and may contain privileged information intended
solely for the named addressee(s). It may not be used or disclosed except
for the purpose for which it has been sent.

If you are not the intended recipient, you must not copy, distribute or take
any action in reliance on it. If you have received this message in error,
please notify Compta by emailing postmasterIZZATcompta.pt quoting the sender and
delete the message and any attached documents.

This footnote confirms that this email message has been swept by MIMEsweeper
for Content Security threats, including computer viruses
***************************************************************************

***************************************************************************
Este email assim como os ficheiros que possa ter em anexo sao confidenciais
e para uso exclusivo da pessoa ou organizacao para o qual foi enviado. Se
recebeu esta mensagem por engano por favor notifique a Compta atraves do
endereco postmasterIZZATcompta.pt

Esta mensagem foi verificada pelo sistema MAILsweeper nao tendo sido
encontrados virus. http://www.mimesweeper.com

MAILsweeper - Modulo da suite MIMEsweeper, solucao de filtragem de conteudos
comercializada pela Compta SA.

A Compta SA detem o mais alto nivel de especializacao MIMEsweeper, tendo
sido reconhecida pela Clearswift como Premier Partner.
***************************************************************************
This message is confidential and may contain privileged information intended
solely for the named addressee(s). It may not be used or disclosed except
for the purpose for which it has been sent.

If you are not the intended recipient, you must not copy, distribute or take
any action in reliance on it. If you have received this message in error,
please notify Compta by emailing postmasterIZZATcompta.pt quoting the sender and
delete the message and any attached documents.

This footnote confirms that this email message has been swept by MIMEsweeper
for Content Security threats, including computer viruses
***************************************************************************

____________________
The Load Balancing Mailing List
Unsubscribe: mailto:majordomoIZZATvegan.net?body=unsubscribe%20lb-l
Archive: http://vegan.net/lb/archive
LBDigest: http://lbdigest.com
MRTG with SLB: http://vegan.net/MRTG
Hosted by: http://www.tokkisystems.com



This archive was generated by hypermail 2.1.4 : Tue Jul 13 2004 - 03:42:48 EDT