[pgpool-general: 5372] Re: [pgpool] Streaming Replication - Identify Slave Node Status

[Anushka Weerakkodyge]

Hi Tatsuo,

Tried setting weight to 0 for the master node. But still transaction is
waiting for the slave node, which is the default behavior of synchronous
streaming replication. If I forcibly stop it then modifications can be seen
in the master node. Any suggestions ?


Thanks,
Anushka

On Thu, Mar 16, 2017 at 4:20 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Hi all,
> >
> > I have a synchronous streaming replication environment which is
> implemented
> > using inbuilt replication mechanism in postgresql. There is a requirement
> > that I need to fail the data modification transactions on master node if
> > the slave node is down. (ie: transactions should commit when only both
> > servers are up and running)
> >
> > Please let me know whether there is a way to identify slave node status
> and
> > fail the transaction using pgpool ?
>
> There's no direct way to do that for now.
>
> However, if you always start an explicit transaction, and set load
> balance weight for master to 0, Pgpool-II always starts a transaction
> for not only primary, but for standby as well. So when user sends a
> commit to Pgpool-II, it will send the commit to both primary and
> standby. If the standby is not up and running (or Pgpool-II cannot
> reach to the standby), the commit request on the primary will fail.
>
> I have not tested it yet though.
>
> 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/20170316/bd5dc5fb/attachment.html>