Re: replica of database

On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote:
> On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <cbbrowne(at)acm(dot)org> wrote:
> > jd(at)commandprompt(dot)com ("Joshua D. Drake") writes:
> >> Aftab Alam wrote:
> >>> Yes ,I want a replica of my db so that I can use it as failover
> >>>
> >>>
> >>>
> >>> Version 7.3 linux AS release 4 update 6
> >>
> >> Version 7.3 is end of life and I don't know of *any* of the
> >> replication technologies that will work with it.
> >
> > Slony-I version 1.1 can still work with 7.3. We ceased support of 7.3
> > when we released v1.2, but recommended, at the time, using 1.1 for
> > 7.3-compatibility.
> >
>
> And as buggy as slony 1.0 might have been, I ran it for about 2 years
> in production replicating a HUGE amount of data daily with zero
> failures. Of course, the servers were fast and reliable, so that might
> have helped cover a lot of issues other people had for us.

And when we ran it we had replica's getting corrupted due to bugs almost
weekly (based on a particular pattern of activity). The edges are
there. It did never lose data on us.

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.