[Pgpool-general] replication questions

[Przemysław Deć]

Any help with this?

----- Oryginalna wiadomość -----
Od: "Przemysław Deć" <pd at linuxpolska.pl>
Do: pgpool-general at pgfoundry.org
Wysłane: poniedziałek, 27 wrzesień 2010 16:21:17
Temat: [Pgpool-general] replication questions

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
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general