From: Simon Riggs <simon@2ndQuadrant.com>
To: Josh Berkus <josh@postgresql.org>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: greg@2ndQuadrant.com, Hannu Krosing <hannu@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
Date: Sat, 01 Jan 2011 23:08:42 +0000
Message-ID: <1293923322.1892.65820.camel@ebony> (raw)
In-Reply-To: <4D1FAD55.1090304@postgresql.org>
References: <1293729972.1892.23804.camel@ebony>
<4D1CC47E.7050207@kaltenbrunner.cc>
<1293735853.1892.24886.camel@ebony>
<AANLkTi=SvN2KQ1Tzh-tRKcXD0i2FyWFBbbR=kXXdepqN@mail.gmail.com>
<4D1D8B2F.5070001@2ndquadrant.com>
<4D1DAB14.5000800@enterprisedb.com>
<1293796137.1892.37313.camel@ebony>
<4D1DCF5A.7070808@enterprisedb.com>
<1293822959.1892.43164.camel@ebony>
<4D1F332A.90306@kaltenbrunner.cc>
<4D1FAD55.1090304@postgresql.org>
On Sat, 2011-01-01 at 14:40 -0800, Josh Berkus wrote:
> Standby in general deals with the A,D,R triangle (Availability,
> Durability, Response time). "Any one" configuration is the A,R
> configuration, and the only reason to go out with it for 9.1 is
> because it's simpler to implement than the D,R configuration (all
> standbys must ack).
Nicely put. Not the "only reason" though...
As I showed earlier, the AR gives you 99.999% availability and the DR
gives you 94% availability, considering a 3 server config. If you add
more servers, the availability of the DR option gets much worse, very
quickly.
The performance of AR is much better also, and stays same or better as
cluster size increases. DR choice makes performance degrade as cluster
size increases, since it works at the speed of the slowest node.
The fact that I can get "5 Nines" with simpler code makes it even
sweeter.
quorum commit > 1 can improve the durability guarantee of data, but it
also seems that many people wouldn't understand its implications and
would mis-configure it, to our collective embarrassment.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: simon@2ndQuadrant.com, josh@postgresql.org, stefan@kaltenbrunner.cc, heikki.linnakangas@enterprisedb.com, hannu@2ndquadrant.com, robertmhaas@gmail.com
Subject: Re: Sync Rep Design
In-Reply-To: <1293923322.1892.65820.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox