Re: [Dbbalancer-users] write replication

[Daniel V. S. <dv...@ar...>]

Hello Dave.

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.

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.

Regards
Daniel.

PS: I would be glad to hear any suggestions/advices....

On S=E1b 26 Oct 2002 20:12, Dave Peticolas wrote:
> Hello, I am considering using dbbalancer for write replication,
> but the documentation seems to indicate that that feature is
> unfinished and may not handle failures well. Is that the case
> with the current version?
>
> Does anyone have experience using dbbalancer for write replication
> that they could share?
>
> thanks,
> dave

--=20

-----------------------------------------------------
Regards from Spain^H^H^H^H^H England.  Daniel Varela
-----------------------------------------------------

If you think education is expensive, try ignorance.
           -Derek Bok (Former Harvard President)