PGCon2018 - 2.5

PGCon 2018
The PostgreSQL Conference

Avinash Vallarapu

Migration of a 5 Node Oracle RAC to PostgreSQL.

Target audience:

All the DBA’s and Professionals/Management looking to Migrate their Oracle RAC to PostgreSQL but worried about Performance.

This talk includes :

In this proposal, I would like to talk about the methods and tools implemented to Migrate from a 5-Node Oracle RAC to PostgreSQL. It was an Oracle RAC with 5 Nodes designed to automatically load balance and scatter the transactions across multiple nodes for a complex business logic. There was a DR(Disaster Recovery Environment) which was a 5 Node RAC again with the ability to take a Read Traffic for ETL and Reporting. There are several built-in features with Enterprise Version of Oracle which are not claimed to be available for PostgreSQL and thus stopping majority of the users to migrate from Oracle RAC to PostgreSQL. I have overcome all such challenges and implemented a RAC like setup without using any external tools or Multi-Master solutions in the market.

Here is what i am going to talk about, in brief:

  • Design that replaced a 5 Node Oracle RAC setup with PostgreSQL. – Migration of Business Logic from Oracle to PostgreSQL.
  • Migration of Data from Oracle to PostgreSQL and continuous replication to avoid a Major Downtime. – Load Balancers and Connection Poolers implemented to distribute transaction load in PostgreSQL.
  • Use of Foreign Data Wrappers in this Architecture.
  • Tools we used to enable Automatic Failover to make the Application connections redirection seamless.
  • Issues faced during Migration/Upgrade. – Implementation of Plprofiler to understand the performance bottlenecks.
  • Snapshotting Solution we implemented to build the same feature as Oracle History Snapshotting to provide reports equivalent to AWR in Oracle.

Contact

avinash dot vallarapu at gmail dot com