Re: Sync Rep: First Thoughts on Code - Mailing list pgsql-hackers

From Aidan Van Dyk
Subject Re: Sync Rep: First Thoughts on Code
Date
Msg-id 20081211143709.GX26596@yugib.highrise.ca
Whole thread Raw
In response to Re: Sync Rep: First Thoughts on Code  ("Fujii Masao" <masao.fujii@gmail.com>)
Responses Re: Sync Rep: First Thoughts on Code  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
* Fujii Masao <masao.fujii@gmail.com> [081211 05:25]:
> - standalone
>   The primary doesn't archive the WAL only during replication. If replication is
>   not in progress, the primary archives the WAL. That is, the primary switches
>   the modes whenever replication starts / ends.

That scares the hebegebies out of me... I'm doing sync-rep because I
*really* *want* *my* *data* .... *always* ...

I want sync-rep because I'm going to get even *stonger* guarentees on my
data (and, if hot-standby works out, load balancing too, but thats not
*my* primary desire for sync-rep)...

But I'm sure as hell *not* going to throw all my eggs into that slave's
basket and do away with my WAL archive...  Would anyone actually use
that "standby" mode, and if not, why compilcate the code for it?

a.

-- 
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

pgsql-hackers by date:

Previous
From: Dmitry Turin
Date:
Subject: Re: COCOMO & Indians
Next
From: Dmitry Turin
Date:
Subject: Re[2+]: COCOMO & Indians