Re: Synchronous replication: Promotion of Standby to Primary

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Synchronous replication: Promotion of Standby to Primary
Дата
Msg-id 3f0b79eb0905250510s75f8ebccn4155a916f39f6cd5@mail.gmail.com
обсуждение исходный текст
Ответ на Synchronous replication: Promotion of Standby to Primary  ("K, Niranjan (NSN - IN/Bangalore)" <niranjan.k@nsn.com>)
Список pgsql-hackers
Hi,

On Mon, May 25, 2009 at 7:10 PM, Kolb, Harald (NSN - DE/Munich)
<harald.kolb@nsn.com> wrote:
> Hello Fujii,
>
> my name is Harald Kolb, I'm a colleague of Niranjan and I will continue
> his community work since he's currently busy with other topics.
> We are looking for a fast mechanism to activate the switchover. Therfore
> we prefer to use a signal to trigger the standby to become primary,
> since in our case the postmaster will be started via fork by a watchdog.
> The originally intended solution via SIGTERM should be ok.
> In the case the mechanism will be still based on the trigger file
> concept, we would require to have in addition a signal to speed up the
> trigger file detection, since the periodic check might be not fast
> enough.

To be honest, I don't think that such quick detection shortens
the failover time so much (probably it would be shortened only
a few ms).  Instead, we should reduce the time of checkpoint
which occurs at the end of recovery/failover. It might take a few
minutes to end. So, I'd like to emphasize user-friendliness
rather than the failover time in the choice of the way of activation.
What is your opinion?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: forward declaration in c
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: [PATCH] cleanup hashindex for pg_migrator hashindex compat mode (for 8.4)