Enhancing online recovery in SR mode

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

Responses

Browse pgsql-hackers by date

  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