Re: Call for 7.5 feature completion

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: Hans-Jürgen Schönig <postgres@cybertec.at>, "Marc G. Fournier" <scrappy@postgresql.org>, Hannu Krosing <hannu@tm.ee>, Tom Lane <tgl@sss.pgh.pa.us>, Andrew Dunstan <andrew@dunslane.net>, pgsql-hackers@postgresql.org
Date: 2004-05-17T14:18:56Z
Lists: pgsql-hackers
Jan Wieck wrote:
> > I am still wondering about two things:
> > Somebody has posted a 2PC patch - I haven't seen too many comments
> > Somebody has posted sync multimaster replication (PgCluster) - nobody 
> > has commented on that. Maybe I am the only one who has ever tried it ...
> 
> Do you really need someone "commenting" on query based replication? I 
> get goosebumps from just thinking someone would voluntarily push all 
> sequence- or timestamp-generation and other not strictly deterministic 
> functionality into the application to be able to use such a "solution". 
> This is exactly how people work around all the MySQL idiosyncrasies.
> 
> > 
> > Most likely this is not very encourageing for the developers involved ...
> 
> Most hopefully this is very discouraging! Connection pools are a nice 
> thing and I have used pgpool recently with great success, for pooling 
> connections. But attempting to deliver multimaster replication as a 
> byproduct of a connection pool isn't going to become an enterprise 
> feature. And the more half-baked, half-functional and half-reliable 
> replication attempts there are, the harder it will be to finally get a 
> real solution being recognized.

Well, considering we offer _nothing_ for multi-master right now, I think
it is a valuable project.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073