| From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
|---|---|
| To: | pgsql-www(at)postgresql(dot)org |
| Subject: | Wiki editor request |
| Date: | 2020-03-24 13:29:42 |
| Message-ID: | d307e47e-ca12-b3f2-a1c1-61eec0c8b6a6@sqlexec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-www |
Can I be added as an editor to the PG WIKI on migrations from Oracle to
Postgres? I want to add this section:
One special case of Oracle RAC to PG is where they have multiple,
separate heavy-hitting applications connected to the same RAC Cluster.
The mistake is to assume that they can simply migrate these applications
to point to one PG Instance. At this point they miss the big picture of
ACTIVE-ACTIVE (Oracle RAC) and ACTIVE-PASSIVE (PG). While Oracle can
divvy up the applications and load balance them across the Nodes in the
Cluster, there is no such thing in PostgreSQL. Absent some
rearchitecture and/or 3rd party tools, it might be wise to move the
heavy-hitting apps to a one-to-one relationship between APP and PG
Instance. Regards, Michael Vitale
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2020-03-24 16:40:55 | Re: Wiki editor request |
| Previous Message | Dave Page | 2020-03-24 09:14:29 | Re: favicons |