Re: [Dbbalancer-users] write replication

[Dave P. <da...@kr...>]

On Sat, 2002-11-02 at 06:30, Daniel Varela Santoalla wrote:
> Hello Dave.
>=20
> Well, it is not exactly unfinished. It works, but is not the safest thing=
 in=20
> the world. My initial idea when implementing DBBalancer was to get a full=
y=20
> transparent load balancing connection pool. But to use this you need all=20
> balanced databases to be in sync, and since no stable replication options=
=20
> where available for Postgres in 2000, I provided this "kind of" replicati=
on=20
> for the meantime. But the final idea is to use DBBalancer combined with=20
> "backend" replication.
>=20
> Now should work correctly, but a write will fail if "any" of the backends=
 fail=20
> to write correctly, which may/may not be the correct thing to do dependin=
g on=20
> which enviroment you are, since it assures sync, but divides the reliabil=
ity=20
> of the system.

Ah, ok, thanks very much for the information.

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?

thanks,
dave