[pgpool-general: 3804] Re: Load balancing questions

Tatsuo Ishii ishii at postgresql.org
Sun Jun 14 12:05:08 JST 2015


> How does load balancing interact with transactions?  We have a gui
> application that does inserts and updates followed immediately by a select
> to render the results... How do we ensure those selects always go to the
> master?

Assuming that you are using streaming replication mode, you can start
an explicit transaction and within the transaction you issue an
insert/update then issue a select to render the result. This way, the
select after the insert/update is always redirected to master.

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