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