I would like you to join me on our journey from a complex, multi instance Oracle topology to a single logical database in PostgreSQL.
Each technology and architectural decision point will be discussed describing how we arrived at our destination.
There are five keys areas that will be covered:
- Target architecture
- Migration of database objects (tables, indexes, views, synonyms, etc)
- Migration of database code (packages, functions, procedures, triggers)
- Application tier
- Migration of Data - with minimal downtime during cutover
The target architecture is a BDR cluster, where the physical data model and data stored is different between the logical standbys and the lead master/shadow master. Will discuss how this allowed for the simplification of the topology, and the benefits this delivered.
Before you go there, yes I know PostgreSQL does no have synonyms, but an alternative approach was needed.
There is a significant amount of business logic in the database tier all of which needed to be translated into database code. Will look at the tools and extensions available to reproduce the functionality in PostgreSQL.
Look at common non-ISO standard SQL embedded in the application tier, along with jdbc challenges.
Finally a look at some of the data movement tools available.
Full disclosure, we are still on the journey but have learnt a lot on the way.
Registrations for Postgres London 2021 are open. Register now to reserve your spot.
WHERE: Virtual Event WHEN: Wednesday | May 12, 2021