Question about synchronous replication

Поиск
Список
Период
Сортировка
От Borodin Vladimir
Тема Question about synchronous replication
Дата
Msg-id 379BDBBE-EDED-430A-B4B1-A9B663EA9A8F@simply.name
обсуждение исходный текст
Ответы Re: Question about synchronous replication
Список pgsql-general
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? 

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




В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Следующее
От: Vincent de Phily
Дата:
Сообщение: Re: Receiving many more rows than expected