Re: [BDR] vs pgpool-II v3 - Mailing list pgsql-general

From Martín Marqués
Subject Re: [BDR] vs pgpool-II v3
Date
Msg-id 55CD07A3.3030209@2ndquadrant.com
Whole thread Raw
In response to Re: [BDR] vs pgpool-II v3  ("Wayne E. Seguin" <wayneeseguin@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Extension to rewrite queries before execution
Next
From: twoflower
Date:
Subject: Re: SELECT blocks UPDATE