In your mysql setting increase the time-out period. With your application,
include a timing cycle that pings the server every certain time less than
the timeout period. That should remind MySQL server that you are still there
and "alive".
Note this part of the MySQL Manual:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
-----Original Message-----
From: Vasiliy Boulytchev [mailto:vasiliy@xxxxxxxxxxxxxxxx]
Sent: Thursday, May 18, 2006 2:02 PM
To: users@xxxxxxxxxxxxxxxx
Subject: [users@httpd] Apache,php to mysql problem
Ladies and Gents,
Thank you so much for your patience, I will describe my problem in
as
much detail as I can...
Diagram:
Internet
X
XXXXX mysql server
X
LVS Load Balancer
x x
X X
X X
OH1 OH2
Problem:
Apache 2.2 on Server OH2, just stopped connecting to the mysql5
databases on mysql server. Pages just time out.
For now, things are OK, since I disabled web requests going to OH2
in
the load balancer, however, this problem needs to be addressed quickly :)
Things I have tried:
1.) I am able to connect to mysql server via command line...
such as
mysql -H mysqlserver -u username -p databasename -P 3307
2.) I did tcpdumps from both ends, and packets are arriving at
both
destinations. I am able to verify that packet streams look alike. I
turned on the bad server for a second in LVS, tcpdumped a sample stream,
saved it, reloaded LVS, and captured a good connection attempt.
3.) I am able to ping the mysql server from OH2, i am able to
telnet to
port 3307, so I have pretty much established that the problem is not
network connectivity. I have also looked over iptables just for grins.
Nothing useful is being logged to the apache logs :(
PLEASE HELP!
THANKS!
--
Vasiliy Boulytchev
CIT Internet
www.citinternet.com
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info. To
unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 5/17/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 5/17/2006
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|