Re: Synchronous Standalone Master Redoux

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: "'Jose Ildefonso Camargo Tolosa'" <ildefonso(dot)camargo(at)gmail(dot)com>, "'Aidan Van Dyk'" <aidan(at)highrise(dot)ca>
Cc: <sthomas(at)optionshouse(dot)com>, "'Daniel Farina'" <daniel(at)heroku(dot)com>, "'Dimitri Fontaine'" <dimitri(at)2ndquadrant(dot)fr>, <pgsql-hackers(at)postgresql(dot)org>, "'Bruce Momjian'" <bruce(at)momjian(dot)us>
Subject: Re: Synchronous Standalone Master Redoux
Date: 2012-07-13 04:55:37
Message-ID: 002b01cd60b3$bf3f1f90$3dbd5eb0$@kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org]
> On Behalf Of Jose Ildefonso Camargo Tolosa
>>On Thu, Jul 12, 2012 at 9:28 AM, Aidan Van Dyk <aidan(at)highrise(dot)ca> wrote:
> On Thu, Jul 12, 2012 at 9:21 AM, Shaun Thomas <sthomas(at)optionshouse(dot)com>
wrote:
>

> As currently is, the point of: freezing the master because standby
> dies is not good for all cases (and I dare say: for most cases), and
> having to wait for pacemaker or other monitoring to note that, change
> master config and reload... it will cause a service disruption! (for
> several seconds, usually, ~30 seconds).

Yes, this is true that it can cause service disruption, but the same will be
True even if master detects that internally by having timeout.
By keeping this as external, the current behavior of PostgreSQL can be
maintained that
if there is no standy in sync mode, it will wait and still serve the purpose
as externally it can send message for master.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2012-07-13 06:38:51 Re: FW: Allow replacement of bloated primary key indexes without foreign key rebuilds
Previous Message Jeff Janes 2012-07-13 04:55:22 Re: [PERFORM] DELETE vs TRUNCATE explanation