Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.

От

Aidan Van Dyk

Тема

Дата

7 марта 2011 г. в 10:34:34

Msg-id

AANLkTinkzJ=UrLbThZy2KeQg+SjwYqj2r0mDomMwirB7@mail.gmail.com

обсуждение

Ответ на

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. (Andrew Dunstan)

Список

pgsql-hackers

Дерево обсуждения

Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 6 марта 2011 г. в 19:28:59

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 7 марта 2011 г. в 03:30:03

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 7 марта 2011 г. в 03:48:37

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 7 марта 2011 г. в 03:54:40

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Andrew Dunstan <andrew@dunslane.net> 7 марта 2011 г. в 09:30:43

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 7 марта 2011 г. в 10:03:02

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 7 марта 2011 г. в 10:55:27

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Andrew Dunstan <andrew@dunslane.net> 7 марта 2011 г. в 10:21:55

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Aidan Van Dyk <aidan@highrise.ca> 7 марта 2011 г. в 10:34:34

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Andrew Dunstan <andrew@dunslane.net> 7 марта 2011 г. в 11:03:19

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 7 марта 2011 г. в 11:14:03

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 7 марта 2011 г. в 11:47:05

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Andrew Dunstan <andrew@dunslane.net> 7 марта 2011 г. в 11:51:58

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Alvaro Herrera <alvherre@commandprompt.com> 7 марта 2011 г. в 12:10:05

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 06:27:22

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. MARK CALLAGHAN <mdcallag@gmail.com> 18 марта 2011 г. в 10:18:04

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 18 марта 2011 г. в 11:19:45

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 11:52:30

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 12:44:06

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 18 марта 2011 г. в 12:48:11

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 18 марта 2011 г. в 13:19:58

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 16:19:15

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 18 марта 2011 г. в 16:30:34

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 16:34:34

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 16:41:10

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Aidan Van Dyk <aidan@highrise.ca> 22 марта 2011 г. в 17:07:38

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 18 марта 2011 г. в 18:26:23

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 22 марта 2011 г. в 17:38:30

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 23 марта 2011 г. в 04:27:33

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 23 марта 2011 г. в 08:52:34

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 23 марта 2011 г. в 09:16:51

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 23 марта 2011 г. в 12:24:40

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 18 марта 2011 г. в 18:18:38

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 18:24:25

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Simon Riggs <simon@2ndQuadrant.com> 18 марта 2011 г. в 18:30:32

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 18 марта 2011 г. в 18:43:41

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 18:48:50

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 19 марта 2011 г. в 16:27:17

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 18 марта 2011 г. в 19:48:06

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Fujii Masao <masao.fujii@gmail.com> 25 марта 2011 г. в 09:12:39

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 18 марта 2011 г. в 13:33:39

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 13:49:15

Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Greg Stark <gsstark@mit.edu> 18 марта 2011 г. в 14:36:38

Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 16:18:08

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 13:28:17

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 16:22:30

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 18 марта 2011 г. в 10:40:43

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 11:37:39

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. MARK CALLAGHAN <mdcallag@gmail.com> 18 марта 2011 г. в 13:03:12

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Markus Wanner <markus@bluegap.ch> 18 марта 2011 г. в 11:20:18

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. MARK CALLAGHAN <mdcallag@gmail.com> 18 марта 2011 г. в 12:52:31

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Robert Haas <robertmhaas@gmail.com> 18 марта 2011 г. в 10:31:04

Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. Aidan Van Dyk <aidan@highrise.ca> 7 марта 2011 г. в 11:04:31

On Mon, Mar 7, 2011 at 2:21 PM, Andrew Dunstan  wrote:

>> For me, that's enough to call it "synchronous replication". It provides a
>> useful guarantee to the client. But you could argue for an even stricter
>> definition, requiring atomicity so that if a transaction is not successfully
>> replicated for any reason, including crash, it is rolled back in the master
>> too. That would require 2PC.
>>
>
> My worry is that the stricter definition is what many people will expect,
> without reading the fine print.

They they are either already hosed or already using 2PC.

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 по дате отправления

Предыдущее

От: Andrew Dunstan

Дата: 7 марта 2011 г. в 10:21:55

Сообщение: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.

Следующее

От: Kevin Grittner

Дата: 7 марта 2011 г. в 10:55:27

Сообщение: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.