On Thu, Sep 1, 2016 at 1:38 AM, Josh Berkus <josh@agliodbs.com> wrote:
> 2 ( g1, g2, g3 )
>
> where each of g1, g2 and g3 were three replicas with the same name
>
> then if two of the replicas from g1 ack'd the commit would proceed, even
> though no replica from g2 has?
[Checking]
Yes that's the case. If for example I have a set of slaves like that:
application_name | replay_delta | sync_priority | sync_state
------------------+--------------+---------------+------------
node1 | 0 | 1 | sync
node1 | 0 | 1 | sync
node1 | 0 | 1 | potential
node2 | 0 | 2 | potential
node2 | 0 | 2 | potential
node2 | 0 | 2 | potential
node3 | 0 | 0 | async
node3 | 0 | 0 | async
node3 | 0 | 0 | async
=# show synchronous_standby_names ;
synchronous_standby_names
---------------------------
2(node1, node2)
You'd need to have the confirmation to come from two nodes with node1
as application_name because those have the higher priority in the
list.
--
Michael