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

From Tatsuo Ishii
Subject Enhancing online recovery in SR mode
Date
Msg-id 20110505.113446.709601362358530427.t-ishii@sraoss.co.jp
Whole thread Raw
Responses Re: Enhancing online recovery in SR mode  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Dan Ports
Date:
Subject: patch: fix race in SSI's CheckTargetForConflictsIn
Next
From: Tatsuo Ishii
Date:
Subject: Re: Enhancing online recovery in SR mode