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
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users