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