Maximum Availability Architecture(MAA) for PostgreSQL

From: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Maximum Availability Architecture(MAA) for PostgreSQL
Date: 2015-04-08 08:22:00
Message-ID: CAFe9ZTo5z6mCH9p3eUO-wpKFcKioHdfd9OjLDj-2N6NUM_twew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone.

I posted this in the SG mailing list but there wasn't any response. Thus, I
decided to repost it here.

Anyone who is familiar with Oracle database would have heard of the Oracle
Maximum Availability Architecture where Oracle uses a range of products to
prevent the databases from suffering planned and unplanned outages.

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.

Let me know your thoughts!

Cheers!

--
Regards,
Ang Wei Shan

Attachment Content-Type Size
Screen Shot 2015-04-06 at 0.01.12.png image/png 115.6 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ankur Kaushik 2015-04-08 12:02:28 pgdump with batch insert
Previous Message Alvaro Herrera 2015-04-06 22:13:42 Re: how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)