Re: [BDR] vs pgpool-II v3

El 13/08/15 a las 14:37, Wayne E. Seguin escribió:
> The question is specifically about the replication feature mentioned here
> http://www.pgpool.net/mediawiki/index.php/Main_Page for the purposes of
> failing over minimizing downtime.

They aim a completely different problems.

The thing Joshua mentioned about BDR being *async* means that data will
be *eventually* consistent. This tackles the problem with nodes which
are distant (one node in London, another in NY, one in Tokio, ...)

PgPools replication_mode is for nodes on a local network. It would never
scale like BDR with geographically distant nodes.

Conclusion, they don't solve the same problem, so it's hard to compare.

Cheers,

--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services