From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Enhancing online recovery in SR mode |
Date: | 2011-05-05 02:34:46 |
Message-ID: | 20110505.113446.709601362358530427.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2011-05-05 02:49:49 | Re: Enhancing online recovery in SR mode |
Previous Message | Dan Ports | 2011-05-05 01:40:57 | patch: fix race in SSI's CheckTargetForConflictsIn |