BBM’s 150M+ users Oracle to Postgres migration without downtime
summary
BBM migrates a multi-terabyte Oracle auth/metadata cluster to Postgres on GCP for a 150M+ user service, using ora2pg for DDL, Oracle GoldenGate for CDC initial load and two‑month replication, Patroni + pgbouncer + WAL‑E + Datadog for the Postgres stack, and custom scripts for sequences/partitioning; the project spans ~18 months, touches ~6,000 servers and ~400 Cassandra nodes, and finishes with a scripted cutover that achieves 5 minutes DB-only downtime (45 minutes total maintenance) and no data loss, so the migration succeeds.
AI-written summary · about
chapters (8)
- 0:00Start
- 9:04Requirements for this Migration
- 10:36What Are the Migration Steps
- 15:06Partition the Data
- 16:37Pl Sequel Store Procedures
- 21:39Data Migration
- 22:22Etl
- 23:59Initial Data Load
related talks
29mTales from the Field - Oracle to PostgreSQL migrations
37mDatabase Modernization at Cloud Scale: Minimizing Risk and Disruption
59mLarge Scale MySQL Migration to PostgreSQL
51mOracle to PostgreSQL Migration with Near Zero Downtime
08mScaling and innovating with databases
23mCCC Intelligent Solutions Achieves Improved Efficiency with Oracle to AWS PostgreSQL
42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtime
49mPractical Guide to Migrating +100 Large PostgreSQL to the Cloud