Re: Sync Rep Design

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Sync Rep Design
Дата
Msg-id 4D205D650200002500038EDC@gw.wicourts.gov
обсуждение исходный текст
Ответ на Sync Rep Design  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Sync Rep Design  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Simon Riggs  wrote:
> Do you agree that requiring response from 2 sync standbys, or
> locking up, gives us 94% server availability, but 99.9992% data
> durability?
I'm not sure how to answer that.  The calculations so far have been
based around up-time and the probabilities that you have a machine up
at any moment and whether you can have confidence that if you do, you
have all committed transactions represented.  There's been an implied
assumption that the down time is unplanned, but not much else.  The
above question seems to me to get into too many implied assumptions
to feel safe throwing out a number without pinning those down a whole
lot better.  If, for example, that 2% downtime always means the
machine irretrievably went up in smoke, hitting unavailable means
things are unrecoverable.  That's probably not the best assumption
(at least outside of a combat zone), but what is?
-Kevin


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Sync Rep Design
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Sync Rep Design