I have general questions about replication mode
If I have replication_mode=true
and
replication_stop_on_mismatch=false

1. What will happen during execution of query in case of failure on one node 
and success on different node?

In documentation its written that "If set to false, the session is terminated 
and the backends are not degenerated. Default is false."
Does it mean that query will rollback on success node?

2. Are nodes waiting for each other before committing queries? 
Is it possible to access data committed on one node and not yet committed on 
second node in load_balance mode?

3. How load balance mode is working in master/slave mode?
Are read queries distributed always to slave and writes to master?
Has backend_weight parameter any influence on that?

Thanks
Przemek Dec
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to