Re: MySQL fallback servers

Hi again,

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?

Thanks and regards
Urban


Roland Rosenfeld wrote:
> Hi!
> 
> Some years ago I developed a little patch that allows to add multiple
> MySQL servers to the MySQL database backend, so if the first server
> isn't reachable, perdition falls back to the second etc.
> 
> I was sure, that I sent this patch to Simon or to this list, but the
> patch never appeared in the upstream source and when I checked all my
> outbound mail, I didn't find a mail with this patch, so I seem to have
> forgotten to do so.
> 
> Today I updated my patch to the current 1.17.1.  Maybe someone else
> will find this patch useful.
> 
> Tschoeeee
> 
>         Roland
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ______________________________________________
> Perdition-users mailing list
> [email protected]
> http://lists.vergenet.net/listinfo/perdition-users

______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users