[Pgpool-general] parameters replication_stop_on_mismatch

Diego Ayala netdiego81 at gmail.com
Mon Jun 27 15:06:03 UTC 2011


Thanks Lazaro, then to have identical servers must be true and false given the
option of non-identical? I'm beginning to PGPool-II is why I do not quite
understand

El 27 de junio de 2011 09:53, Lazaro Rubén García Martinez <
lgarciam at vnz.uci.cu> escribió:

> I prefer set this parameter to true by knowing if there is a
> synchronization problem in the servers, in the other hand, if in the servers
> there is a problem like this, the users should not be affected. In the
> oficial documentation says:
>
> When set to true, if all backends don't return the same packet kind, the
> backends that differ from most frequent result set are degenerated. A
> typical use case is a SELECT statement part of a transaction,
> replicate_select set to true, and SELECT returning a different number of
> rows among backends. Non-SELECT statements might trigger this though. For
> example, a backend succeeded in an UPDATE, while others failed. Note that
> pgpool does NOT examine the content of records returned by SELECT. If set to
> false, the session is terminated and the backends are not degenerated.
> Default is false.
>
> Regards.
> ________________________________________
> De: pgpool-general-bounces at pgfoundry.org [
> pgpool-general-bounces at pgfoundry.org] En nombre de Diego Ayala [
> netdiego81 at gmail.com]
> Enviado el: lunes, 27 de junio de 2011 8:59
> Para: pgpool-general at pgfoundry.org
> Asunto: [Pgpool-general] parameters replication_stop_on_mismatch
>
> Good morning, I have installed the 3.0.3 version of pgPool-II, I wonder
> what benefits would have true or false triggering, the parameter
> replication_stop_on_mismatch, which is the recommended option ..?
>
> thanks, Diego
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110627/fd201935/attachment.html>


More information about the Pgpool-general mailing list