[pgpool-general: 3802] Load balancing questions (Joe Schaefer)

[Greg Clough]

If you prefix your query with a comment, then that disables the load
balancing and it always goes to the master:

http://www.pgpool.net/mantisbt/view.php?id=109

0000109: Query prefixed with any comment (/* ... */) triggers NO LOAD
BALANCE mode

*Greg Clough*

*Contract Database Administrator | CWT Digital*

*t.* 0845 456 0070 *w.* cwtdigital.com <http://www.cwtdigital.com/>


Units A/B, Level 8 North, New England House,
New England Street, Brighton, East Sussex, BN1 4GH

[image:
https://ci6.googleusercontent.com/proxy/spbuXLCE_kiYn1CBmHRh6DoZX1WwETayC0rma88wNedREVrYPrjvkpQLcBPeuKfSkfkOpDSkuDvye9g2Ps4-BW4s=s0-d-e1-ft#http://www.cwtdigital.com/hosted/twitter.png]
<https://twitter.com/cwtdigital> [image:
https://ci5.googleusercontent.com/proxy/q4GOyacafkMnvs7TLpy3rOcwVK_uxMoECtqVEVpwmxiLShfkGNOZGisnwu4oHGtcEK_C-TfrLguFshp1VKC-5zZw6g=s0-d-e1-ft#http://www.cwtdigital.com/hosted/facebook.png]
<https://www.facebook.com/CWTdigital> [image:
https://ci4.googleusercontent.com/proxy/BVh2CnIvbQ_Rp5LFVzt4p72zUvhG3u7ksBMtlWRjbWjXL-DXIFEXXZJCYWMlSd3MshfG4UN0NAuTj1eElX8r5iu2KQ=s0-d-e1-ft#http://www.cwtdigital.com/hosted/linkedin.png]
<https://www.linkedin.com/company/cwt-digital> [image:
https://ci4.googleusercontent.com/proxy/QJJKpRXCvrkfCat5ycimzE7Lve3Pp9wFZWL5eBF5ELDkpl_gA8UVOc-R2p29DTS5DJmfD-FHGg2cjSf4lEuz2Ts=s0-d-e1-ft#http://www.cwtdigital.com/hosted/google.png]
<https://plus.google.com/s/CWT%20Digital> [image:
https://ci4.googleusercontent.com/proxy/X2ddbFYXE1hmnS4LGzoCr-Pl8fpK6yoO9R-jjF3__nbZkbuCmQR2LD3-Ts3deetyHm0L8E-hjyXeRS0YTkcqtNNGkxM=s0-d-e1-ft#http://www.cwtdigital.com/hosted/instagram.png]
<http://instagram.com/cwtdigital>

On 13 June 2015 at 04:00, <pgpool-general-request at pgpool.net> wrote:

> Send pgpool-general mailing list submissions to
>         pgpool-general at pgpool.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://www.sraoss.jp/mailman/listinfo/pgpool-general
> or, via email, send a message with subject or body 'help' to
>         pgpool-general-request at pgpool.net
>
> You can reach the person managing the list at
>         pgpool-general-owner at pgpool.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pgpool-general digest..."
>
> Today's Topics:
>
>    1. [pgpool-general: 3800] Load balancing questions (Joe Schaefer)
>
>
> ---------- Forwarded message ----------
> From: Joe Schaefer <joesuf4 at gmail.com>
> To: pgpool-general at pgpool.net
> Cc:
> Date: Fri, 12 Jun 2015 15:25:55 -0400
> Subject: [pgpool-general: 3800] Load balancing questions
> 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?
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 610 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 699 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 584 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 688 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 483 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150613/f1936d4d/attachment-0004.png>