[Dbbalancer-users] Re: [fmII/contact] dbblancer

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

On Wed 07 Nov 2001 15:04, you wrote:
> HI,
>
> I have used dbblancer with replication mode on 3 servers  succesfully.
>
> But if i put one of the server off or i stop the postgresql service on one
> of them, I can connect to the writer port of the daemon server.
>

You mean you CAN'T, don't you?

> The load balanlcer works very well.
>
> Could you tell me how to do ? or explain me the running process of the
> write mode??
>
>

Well. First I would like to say that the replication functionality of 
DBBalancer starts from two premises that somewhat limit its features:

a) It had to be a solution external to PostgreSQL, meaning no patches and no 
fiddling with your existent db's
b) It had to be a simple solution, not pretending to cover every situation, 
much less general than the cases pretended to be covered with DBBalancer's 
connection pooling or load balancing.

That resulted in some limitations.

One of them is that if ANY of the replicated DB's fails, there's no way for 
dbbalancer to put it in sync again, so to avoid bigger problems (like db's 
getting permanently out of sync)  all the daemon's connections are 
invalidated till that db starts again and the connections are recovered.

This could (and should to) be improved, but currently I'm more focused on 
getting a good connection pool and load balancer. Anyway, all ideas to get 
this better are of course welcome.

Best regards.
Daniel



-- 

----------------------------------
Regards from Spain.  Daniel Varela
----------------------------------

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