Re: [GENERAL] Postgres HA

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: [GENERAL] Postgres HA
Дата
Msg-id 20170223002608.GA90903@crankycanuck.ca
обсуждение исходный текст
Ответ на [GENERAL] Postgres HA  (Dylan Luong <Dylan.Luong@unisa.edu.au>)
Список pgsql-general
Hi,

On Wed, Feb 22, 2017 at 10:58:10PM +0000, Dylan Luong wrote:
>
> I am looking at options to improve our high availability.

I suspect the central question you have to answer is, "What do you
mean by 'improve'?"

Do you want to increase the ability to retrieve data?  Decrease the
potential for data loss?  Shorten the recovery time to read/write
availability?  And so on.  The answers for these different questions
will determine which trade-off you need to make.

And rest assured, there is abolutely no solution in the world -- not
even a really expensive commercial one -- that requires no trades.
Distributing data reliably with ACID semantics and no data loss or
corruption or loss in write throughput is not possible, at least
today.  You have to pick which poison you want :)

A

--
Andrew Sullivan
ajs@crankycanuck.ca


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Следующее
От: Julyanto Sutandang
Дата:
Сообщение: Re: [GENERAL] Postgres HA