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

[Joe Schaefer]

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
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150614/35c43efd/attachment.html>