-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Here is my suggestion:
When set to true, if a SELECT statement returns a result set of records different between the backends, the backends that differ from the master are degenerated. This is only valid if the SELECT statement is part of a transaction and replicate_select is set to true. If set to false, the session is terminated and the backends are not degenerated. Default is false. - -Ramon On 06/06/2010 10:25 PM, Tatsuo Ishii wrote: >> BTW : what is 'replication_stop_on_mismatch' and has it got anything to do >> with this issue ? > > replication_stop_on_mismatch only affects SELECT. So it does not > anything to do with the issue. > > I have to admit that current document regarding > replication_stop_on_mismatch is quite incorrect and hard to > understand: > > "When set to true, pgpool-II degenerates the backends and keeps the > service only with the Master DB if data mismatch occurs. If false, > pgpool-II just terminates the query. Default is false." > > Probably enhanced description for this would be something like > this. Please correct or raise questions. Grammatical corrections are > welcome as well. > > "When set to true, if a backend returns different number of rows from > other backends return in SELECT (or SHOW), pgpool-II degenerates > it. This only take effects when the SELECT is running in an explicit > transaction and replicate_select is set to true. If false, pgpool-II > just terminates the session. Default is false." > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwO160ACgkQGIS0iEuhp4MFVACdFrC9kvAvN20wz3PK4afu3f15 dRoAoMaVA1bwxHlQt3oXAPL6nQ2qpGB8 =bEVA -----END PGP SIGNATURE----- _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
