<div dir="ltr">Hi Bo,<div><br></div><div>Can you explain the rationale for sending prepared statements to only the primary node? If a prepared statement contains an UPDATE or INSERT - will this result in the back-end databases being out-of-sync if native replication is being used, since the query is only sent to the primary node?</div><div><br></div><div>Thanks,</div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div style="margin:0px;padding:0px 0px 20px;width:936px;color:rgb(34,34,34);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div style="margin:8px 0px 0px;padding:0px"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><table cellpadding="0" cellspacing="0" style="border-spacing:0px;border-collapse:collapse;color:rgb(68,68,68);width:480px;font-size:9pt;font-family:Arial,sans-serif;line-height:14px"><tbody><tr><td colspan="2" style="padding:0px 0px 5px;width:480px;color:rgb(60,60,59)"><span style="font-family:Arial,sans-serif;color:rgb(29,37,45)"><font size="4"><br>MATTHEW MACDONALD</font></span></td></tr><tr><td colspan="2" style="padding:0px 0px 5px;width:480px;color:rgb(23,147,210)"></td></tr></tbody></table></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 26, 2020 at 4:44 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">hello,<br>
<br>
On Fri, 22 May 2020 17:58:00 +0200<br>
Franco Ricci <<a href="mailto:franco.ricc@gmail.com" target="_blank">franco.ricc@gmail.com</a>> wrote:<br>
<br>
> I’s possible specify which server should execute a "prepared statement"?<br>
> I noticed in pgpool 4.1 that ordinary query are routed on master or slave server according query action (SELECT, UPDATE etc.).<br>
> If I create a PREPARE STATEMENT this query is routed always on master server and never executed on slave even if statements is only a SELECT query!<br>
> <br>
> There is a way to programmatic set which is the server that has to server a prepared statement?<br>
<br>
No.<br>
Pgpool doesn't load balance "prepared statement".<br>
"Prepared statement" should be sent to primary only.<br>
<br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
</blockquote></div>