On Apr 20, 2008, at 5:48 AM, Michael Gruetzner wrote:
The Slony-1 documetation says that it might not be suitable if some
nodes may
fail oftenly but it does not explain how slony deals with such
failures (maybe someone
can explain this to me?).
Slony deals well with hosts which go offline for a bit. The problem
lies with the amount of change your DB has. If you're doing millions
of updates per day, then slony has to queue up all those changes to
apply later.
If your WAN can handle that much data flying across, you're ok. It
must also be able to handle your normal volume plus any backlog
updates that slony needs to apply.
So what I'm asking is: Does anyone have experience with Slony-1 and
wide area
clusters?
I do, but the one application that I do this for has perhaps a dozen
insert/update/delete per day. Having four or five day downtime is a
total non-issue for this case. I only do it with two nodes.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general