Skip site navigation (1) Skip section navigation (2)

Re: Synchronous Standalone Master Redoux

From: Daniel Farina <daniel(at)heroku(dot)com>
To: sthomas(at)optionshouse(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Synchronous Standalone Master Redoux
Date: 2012-07-10 15:46:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Tue, Jul 10, 2012 at 6:28 AM, Shaun Thomas <sthomas(at)optionshouse(dot)com> wrote:
> On 07/10/2012 01:11 AM, Daniel Farina wrote:
>> So if I get this straight, what you are saying is "be asynchronous
>> replication unless someone is around, in which case be synchronous"
>> is the mode you want.
> Er, no. I think I see where you might have gotten that, but no.

From your other communications, this sounds like exactly what you
want, because RAID-1 is rather like this: on writes, a degraded RAID-1
needs not wait on its (non-existent) mirror, and can be faster, but
once it has caught up it is not allowed to leave synchronization,
which is slower than writing to one disk alone, since it is the
maximum of the time taken to write to two disks.  While in the
degraded state there is effectively only one copy of the data, and
while a mirror rebuild is occurring the replication is effectively
asynchronous to bring it up to date.


In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2012-07-10 15:49:49
Subject: Re: expression evaluation with expected datatypes
Previous:From: Alvaro HerreraDate: 2012-07-10 15:40:08
Subject: Re: Re: Allow replacement of bloated primary key indexes without foreign key rebuilds

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group