[pgpool-general: 6103] Re: read your own writes
Christophe Pettus
xof at thebuild.com
Thu May 24 01:16:21 JST 2018
> On May 23, 2018, at 08:42, Mario V <mariovikale at hotmail.com> wrote:
> Is there a way to enforce this stickiness so that all statements belonging to the same transaction would go to the same node
> which in this case would be the primary?
If the entire sequence is wrapped in a transaction:
BEGIN;
-- writes
-- reads
COMMIT;
The reads will always come from the primary, since all explicit transactions are routed to the primary.
--
-- Christophe Pettus
xof at thebuild.com
More information about the pgpool-general
mailing list