-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 When set to true, if a SELECT statement returns a result set of records different between the backends, the backends that differ from most frequent result set 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/08/2010 09:49 PM, Tatsuo Ishii wrote: > Thanks. Actgually "the backends that differ from the master are > degenerated" is different from the current implementaion. To choose > the victim backend, we use "decide by majority". Suppose we have 3 > nodes and they return: > > Node 0: A > Node 1: B > Node 2: B > > Then the victim is Node 0. > > Suppose we have 4 nodes: > > Node 0: A > Node 1: A > Node 2: B > Node 3: B > > Unfortunately no one looses. In this case we chose Node 2 & 3 as > victims since Node 0 votes A. > > Can you please modify your proposal? > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > >> 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----- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwPEU8ACgkQGIS0iEuhp4PYsQCfXgV5AoZeei4a9kyhNW5kcAPB StwAoJWzjEEtp0dEL7XhOytM65w1u2ww =Z9Qr -----END PGP SIGNATURE----- _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
