Re: Replication Ideas

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Replication Ideas
Дата
Msg-id 3F4E6D52.90206@Yahoo.com
обсуждение исходный текст
Ответ на Re: Replication Ideas  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Replication Ideas  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general

Ron Johnson wrote:

> Notes:
> a) this is, of course, not *sufficient* for multi-master
> b) yes, you need a fast, low latency network for the DLM chatter.

"Fast" is an understatement. The DLM you're talking about would (in our
case) need to use Spread's AGREED_MESS or SAFE_MESS service type,
meaning guarantee of total order. A transaction that needs any type of
lock sends that request into the DLM group and then waits. The incoming
stream of lock messages determines success or failure. With the overhead
of these service types I don't think one single communication group for
all database backends in the whole cluster guaranteeing total order will
be that efficient.

>
> This is a tried and true method of synchronization.  DEC Rdb/VMS
> has been using it for 19 years as the underpinnings of it's cluster
> technology, and Oracle licensed it from them (well, really Compaq)
> for it's 9i RAC.

Are you sure they're using it that way?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: left outer join terrible slow compared to inner join
Следующее
От: "Jenny -"
Дата:
Сообщение: running bdg on postgresql`