[pgpool-general: 8050] Re: delay_threshold redirect to replicas
Franklin Anderson de Oliveira Souza
franklinbr at gmail.com
Mon Mar 14 12:00:48 JST 2022
Owww !!!!
Thank you so much!
Em dom., 13 de mar. de 2022 às 20:31, Bo Peng <pengbo at sraoss.co.jp>
escreveu:
> Hello,
>
> On Sun, 13 Mar 2022 14:42:59 -0400
> Franklin Anderson de Oliveira Souza <franklinbr at gmail.com> wrote:
>
> > hello dear,
> >
> > is it possible to redirect queries to other replicas instead of the
> master
> > when the delay_threshold limit is exceeded!? the default is to redirect
> to
> > master.
>
> If you are uing Pgpool-II 4.3.x, you can enable
> "prefer_lower_delay_standby" parametr
> to route the queries to the standby with the least delay.
>
>
> https://www.pgpool.net/docs/latest/en/html/runtime-streaming-replication-check.html#GUC-PREFER-LOWER-DELAY-STANDBY
>
> > Tanks !
> > --
> > Enviado do Gmail para celular
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
> http://www.sraoss.co.jp/
>
--
Enviado do Gmail para celular
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220313/c63169b8/attachment.htm>
More information about the pgpool-general
mailing list