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 |
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) |