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,
Pennsylvania19073
