Re: Update on replication - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: Update on replication
Date
Msg-id 20021217214338.A63985-100000@hub.org
Whole thread Raw
In response to Re: Update on replication  (Greg Copeland <greg@CopelandConsulting.Net>)
Responses Re: Update on replication
List pgsql-hackers
On Tue, 17 Dec 2002, Greg Copeland wrote:

> 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?

Just checked on Usogres, and it appears to be relatively up to date, in
that it is known to work up to 7.2.1:
    http://usogres.good-day.net/working.php3

Searching Google for QueryMaster finds a few Japanese sites, but I can't
read Japanese :(

Tatsuo, can you help?


pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: Update on replication
Next
From: Bruce Momjian
Date:
Subject: Re: Update on replication