Hi Urban!
On Fri, 31 Jul 2009, Urban Loesch wrote:
I tried the patch and it works as expected. Great :-)
I have only one problem.
If I shut down the first DB backend (the hole server, it does no more
respond -> simulating a total network failure) it takes about 3 minutes
to automatically failover to the second backend.
This because "mysql_real_connect" uses the default tcp configuration of
the kernel.
net.ipv4.tcp_syn_retries = 5
This timeout seem's to long. A timeout of about 15 seconds should be enough.
Changing the default kernel tcp configuration is not possible for me,
because there are running some more virtual servers on this hardware,
and all are sharing the same kernel.
How do you deal with this timeout problem?
To say the truth, I never tried this out before. For testing purpose
I simply stopped the MySQL server, which works as expected.
But you are true, I can reproduce the problem with a switched off
server. Google only told me, that we aren't alone with this problem
(
http://forums.mysql.com/read.php?45,62601,62601), but I didn't find a
simple solution for this :-(
Tschoeeee
Roland
--
Roland Rosenfeld - Content Delivery - NED - Technik
NetCologne Gesellschaft für Telekommunikation mbH - HRB 25580, AG Köln
Am Coloneum 9 50829 Köln Tel.: +49-221-2222-373 Fax: +49-221-2222-7373
Geschäftsführer: Werner Hanf, Karl-Heinz Zankel