Re: Issues with Quorum Commit

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Issues with Quorum Commit
Дата
Msg-id 4CAE07E5.6090403@agliodbs.com
обсуждение исходный текст
Ответ на Re: Issues with Quorum Commit  (Aidan Van Dyk <aidan@highrise.ca>)
Список pgsql-hackers
> If you want "synchronous replication" because you want "query
> availabilty" while making sure you're not getting "stale" queries from
> all your slaves, than using your k < N (k = 3 and N - 10) situation is
> screwing your self.

Correct. If that is your reason for synch standby, then you should be
using k = N configuration.

However, some people are willing to sacrifice consistency for durability
and availability.  We should give them that option (eventually), since
among that triad you can never have more than two.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: standby registration (was: is sync rep stalled?)
Следующее
От: Markus Wanner
Дата:
Сообщение: Re: Issues with Quorum Commit