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

Reply via email to