Re: [Dbbalancer-users] write replication

[Andrew M. <an...@ca...>]

On Sun, 2002-11-03 at 11:30, Dave Peticolas wrote:
> 
> As far as backend replication goes, my limited research hasn't
> turned up any really viable free software alternatives. The currently
> available choices all seem rather limited or awkward to use. Is that
> your experience or do you have a suggested replication package to use?

Hi Dave,

I think that the plan is to include updated replication code into
PostgreSQL at some stage fairly soon.

For my last project we rolled our own back-end replication, which was
somewhat simplified by a clear set of input XML transactions effecting
change to the database.  We were able to identify these transactions and
pass them to other backends for interpretation, hashing the result for
verification.

For myself I use DBBalancer for database pooling, although the model of
only committing to all backends if a transaction has been successful in
all cases is a good way towards 2phase commit.

Regards,
					Andrew.
-- 
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/ 
---------------------------------------------------------------------