Re: Enhancing online recovery in SR mode - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Enhancing online recovery in SR mode
Date
Msg-id 20110505.114949.938838038238400484.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Enhancing online recovery in SR mode  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Oops. This should have been posted to pgpool-hackers. Sorry for noise.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> I have just committed changes to enhance online recovery in streaming
> replication mode. Pgpool-II had to restart child process to recognize
> failback node. Now pgpool-II becomes a little bit smarter and does not
> need to restart children. This means that client sessions started
> before online recovery can continue while doing online recovery.
> 
> The trick is to have local backend status cache in pgpool child. It
> copies backend status into local memory. Thus the process continues to
> disregard failback node until the session ends. Once the session ends,
> the process exits with status 1, and pgpool-II main restart new one,
> which will recognize failback node.
> 
> Note that this enhancement is applied to pcp_attach_node as well.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Enhancing online recovery in SR mode
Next
From: Tom Lane
Date:
Subject: Re: Some surprising precedence behavior in PG's grammar