Postgres Pro
Downloads
Home   >   mailing lists

Re: Maximum Availability Architecture(MAA) for PostgreSQL - Mailing list pgsql-admin

From mark
Subject Re: Maximum Availability Architecture(MAA) for PostgreSQL
Date
Msg-id CAKD=pjjzjNV57KJYWZ18VriO3nu2Q-oTr3TEEnFQ89yYHOgOuQ@mail.gmail.com
Whole thread Raw
In response to Re: Maximum Availability Architecture(MAA) for PostgreSQL  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view

Am 2015-04-08 10:22, schrieb Wei Shan:
In the PostgreSQL world, what do you guys think would be the
equivalent?

Attached is a diagram I have thought of. Clusters of pg-pool2 used to
load balance the connection in and for connection failover when a DB
crashes. Between master and slave, sync replication is being used for
zero-data-loss.






If you haven't already, You probably should take a look at BDR: https://wiki.postgresql.org/wiki/BDR_Quick_Start

 -Mark

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Maximum Availability Architecture(MAA) for PostgreSQL
Next
From: Ankur Kaushik
Date:
Subject: Schema sync or compare