From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Comparison between Postgres-XC, Pgcluster-ii, BDR-1.07,Xdb Replication Server,Bucardo
Date: Tue, 28 Aug 2018 22:20:42 -0700 (MST)
Message-ID: <1535520042142-0.post@n3.nabble.com> (raw)
Hi All,
I am looking for Active-Active clustering(HA) in Postgres along with DR.
Totally planning for HADR in postgres. I gone through the above mentioned
tools. Confused which one to rely on.
Can anyone help me in understanding the comparison between the above
mentioned tools on the following grounds:
<http://www.postgresql-archive.org/file/t351175/bdrfeaturematrix_gjpztch.jpg;
Even Though good at understanding each tool separately, I think it is better
to build a comparison matrix on the common criteria, please provide me the
inputs for the following :
1 Supports(MMR/SMR; with/without updatable target)
2 Source Environments(OS pre-requisites)
3 Target Environments(OS pre-requisites)
4 Latency
5 Resiliency
6 Ease of Use
7 External Tools/Plugins Used
8 Administration Interface
9 Advantages
10 Disadvantages
11 Minimum DB Version
12 Throughput(transactions-per-second/no.of.clients)
13 Limitations
14 Workload
15 CPU Overhead
16 Cost
17 Suitable
18 Failover
19 Network Required
20 Distance(if any)
21 Replication Protocol
22 Filtering(Selective Replication)
23 Filtering(Selective Replication) Done at(Source/Target)
24 Suitable for(Uni-Directional/Bi-Directional)
25 Writability on Master
26 Writablity on Slave
27 Native/ Third party
28 Synchronization modes(Synchronous/Asynchronous)
29 Data Level of Replication(Changes are replicated in Block/Page level or
Row level ?)
30 Master-Slave/Master-Master Relationship(one to many or one to one)
31 Transactional Consistency(Guaranteed or not?)
32 Licensed/Opensource
33 Official Installation & Setup guide(if any)
We are trying to choose one among the above mentioned tools based on the
above mentioned(33) criterias. Please help me to choose the best out of
this. I will be gladful if I could the all the 33 criterias like above
image(which gives me/many people a concrete solution when going for HADR in
postgres).
Looking forward to hear from you. Thank you in Advance.
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: Comparison between Postgres-XC, Pgcluster-ii, BDR-1.07,Xdb Replication Server,Bucardo
In-Reply-To: <1535520042142-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox