| 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: | Whole Thread | Raw Message | 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) |