Any help with this? ----- Oryginalna wiadomość ----- Od: "Przemysław Deć" <[email protected]> Do: [email protected] 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 [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
