Re: Question about synchronous replication

On 05/12/2014 09:42 AM, Borodin Vladimir wrote:
> Hi all.
>
> Right now synchronous replication in postgresql chooses one replica as
> synchronous and waits for replies from it (with synchronous_commit = on
> | remote_write) until this replica host does not disconnect from master.
>
> Are there any plans to implement something like semi synchronous
> replication in MySQL 5.6 or replication with write_concern=2 in MongoDB
> when the master waits for a reply from any of the replica hosts?

This does not work for what you want?:

http://www.postgresql.org/docs/9.3/interactive/runtime-config-replication.html#GUC-SYNCHRONOUS-STANDBY-NAMES

>
> In this case network flaps between master and any one replica will not
> affect writing load and in case of master fail it would be necessary to
> find the most recent replica and promote it. Or there are pitfalls that
> I do not see?
>
> --
> Vladimir
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com