Re: Update on replication

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?