Re: MySQL fallback servers
Roland Rosenfeld <[email protected]>
| Newsgroups | gmane.mail.perdition.user |
|---|---|
| Message-ID | <[email protected]> |
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
______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users