[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