Re: Update on replication

On Tue, 2002-12-17 at 19:38, Marc G. Fournier wrote:
> On Wed, 18 Dec 2002, Tatsuo Ishii wrote:
>
> > > I just got my copy of SysAdmin Magazine and was surprised to see an
> > > article about Usogres -- The PostgreSQL Replication Tool.
> > >
> > > I don't remember seeing it mentioned on this or the General list. Though
> > > I just started reading the article and don't have a firm grasp on it yet,
> > > I do remember a discussion of replication using this technique - described
> > > in the first two paragraphs.
> >
> > Glad to hear that. Usogres was developed in Japan and pretty popular
> > ammong Japanese PostgreSQL community.
> >
> > BTW, there is a commercial product called QueryMaster, which takes
> > similar approach to Usogres. It copies the input query and distribute
> > to multiple PostgreSQL servers. As long as one of a server is working,
> > users even do not notice some of them are failing.
>
> How come these solutions are such well kept secrets? I've heard of
> neither in relation to past discussions about replication, or have I just
> missed them? :(
>

Good questions. I've heard of Usogres, more or less in passing, but
heard it didn't work very well. Also heard that it wasn't reliable or a
serious solution. I seem to remember hearing that it only worked on
much older versions of PostgreSQL. Of course, I'm not attempting to
assert any true to what I've heard but since it's being talking about,
perhaps someone can clarify how well it REALLY works. Perhaps even
provide some more details on it?

Never heard of QueryMaster. Perhaps someone would like to talk a little
more about that as well?

--
Greg Copeland <greg(at)copelandconsulting(dot)net>
Copeland Computer Consulting