Re: Replication - Mailing list pgsql-hackers

From Markus Schiltknecht
Subject Re: Replication
Date
Msg-id 44EA06B4.7030902@bluegap.ch
Whole thread Raw
In response to Re: Replication  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff Davis wrote:
> Synchronous replication (to me) means that the data has been written to
> permanent storage on all masters and all slaves before any master or
> slave reports a successful COMMIT. Are you suggesting that you ship the
> WAL over the network, wait for it to be written to the slave, and then
> report a successful commit?

I'm not suggesting doing replication like that. But I think that's what 
people mean when they propose that "multi-master synchronous replication 
would be fairly trivial to implement with 2PC and wal-shipping".

This is more or less trivial to implement, yes. But it won't scale.

Regards

Markus


pgsql-hackers by date:

Previous
From: AgentM
Date:
Subject: Re: Replication
Next
From: Alvaro Herrera
Date:
Subject: Re: Replication