[pgpool-general: 3806] Re: Load balancing questions
joesuf4 at gmail.com
Sun Jun 14 23:45:53 JST 2015
Thank you Tatsuo that's great to hear!
On Sat, Jun 13, 2015 at 11:05 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> > How does load balancing interact with transactions? We have a gui
> > application that does inserts and updates followed immediately by a
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general