Thread: Wiki editor request
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
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
On 3/24/20 9:29 AM, MichaelDBA wrote: > 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 For the archives -- done Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development