Re: Replication Ideas

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication Ideas
Date: 2003-08-28 22:52:24
Message-ID: 3F4E87A8.9010005@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Are these clusters physically together using dedicate LAN lines .... or
are they synchronizing over the Interwait?

Ron Johnson wrote:

>On Thu, 2003-08-28 at 16:00, Jan Wieck wrote:
>
>
>>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.
>>
>>
>
>I guess it's the differing protocols involved. DEC made clustering
>(including Rdb/VMS) work over an 80Mbps protocol, back in The Day,
>and HPaq says that it works fine now over fast ethernet.
>
>
>
>>>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?
>>
>>
>
>Not as sure as I am that the sun will rise in the east tomorrow,
>but, yes, I am highly confident that O modified DLM for use in
>9i RAC. Note that O purchased Rdb/VMS from DEC back in 1994, along
>with the Engineers, so they have long knowledge of how it works
>in VMS. One of the reasons they bought Rdb was to merge the tech-
>nology into RDBMS.
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-08-28 23:34:30 Re: Books for PostgreSQL?
Previous Message Doug McNaught 2003-08-28 22:36:18 Re: backends

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-08-28 22:58:34 Re: Obscure: correctness of lock manager???
Previous Message Tom Lane 2003-08-28 22:43:48 Re: Bumping block size to 16K on FreeBSD...

Browse pgsql-performance by date

  From Date Subject
Next Message Ken Geis 2003-08-29 00:10:31 bad estimates / non-scanning aggregates
Previous Message Ron Johnson 2003-08-28 22:04:19 Re: Replication Ideas