From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Enhancing online recovery in SR mode |
Date: | 2011-05-05 02:49:49 |
Message-ID: | 20110505.114949.938838038238400484.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-05 03:03:00 | Re: Some surprising precedence behavior in PG's grammar |
Previous Message | Tatsuo Ishii | 2011-05-05 02:34:46 | Enhancing online recovery in SR mode |