[pgpool-general: 6104] Re: read your own writes
Tatsuo Ishii
ishii at sraoss.co.jp
Thu May 24 10:17:27 JST 2018
>> On May 23, 2018, at 08:42, Mario V <mariovikale at hotmail.com> wrote:
>> Is there a way to enforce this stickiness so that all statements belonging to the same transaction would go to the same node
>> which in this case would be the primary?
>
> If the entire sequence is wrapped in a transaction:
>
> BEGIN;
> -- writes
> -- reads
> COMMIT;
>
> The reads will always come from the primary, since all explicit transactions are routed to the primary.
With upcoming Pgpool-II 4.0, which is supposed to be released by the
end of this year, will do this even outside transactions. This has
been already in master branch. Also I wrote a small blog regarding
this feature.
http://pgsqlpgpool.blogspot.jp/2018/04/more-load-balancing-fine-control.html
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list