Re: dbmirror

On Mon, 17 May 2004 18:13:36 +0100
Richard Huxton <dev(at)archonet(dot)com> wrote:

> Jeff wrote:
> > Slony-I is an async replication system.
> > It is pre-beta, but already it works very well. I'm using it in
> > production with 5 slaves!
> >
> > http://gborg.postgresql.org/projects/slony1/
>
> Any chance of a quick review - installation issues, experience in use?
>

It is a little light on the documentation front at the moment, when I
get some time I'll be writing some. But I found the test scripts gave
enough info (along with what documentation was there) to get going.

I ran into a couple problems which I fixed (an issue with multiple
replication sets and another thread locking issue that tickled a
kerberos issue (Which actually was fixed in 7.5's libpq)).

Its now working fine in production. We're replicating about 150k
insert/update/deletes every hour.

The author of slony is very nice and willing to help out.
We have an irc channel on irc.freenode.net - #slony where we can try to
help if you have problems.

I must say, it does work better than eRserver which has a nasty habit of
running into java errors and dying (and dying again when restarting).
(encountering > 7bit ascii in a sql_ascii db causes jdbc to die..
although libpq, etc. have no issues with the 7bit ascii)

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/