2022 / 07 / 30
10:40 ~ 11:10
TR310-1
PostgreSQL, Create your own DATABASE by PostgreSQL Taiwan
透過 AWS SCT 與 DMS 從 MySQL 微痛移植到 PostgreSQL
by
韓政璇
¶ Agenda
¶ 1. Intro
- Who
- Why
- What (will & will NOT be included in the talk)
¶ 2. Intro - AWS
- SCT
- DMS
¶ 3. How we approached the migration
- Context
- What
- Legacy system
- Why
- The reason why we needed the migration
- To ensure legacy system’s usability while migrating features to the new system
- For Ecto’s multi-schema TX
- The reason why we needed the migration
- How - initial plannings
- What
- Issues we faced during the migration
- View’s dependency hell
- Broken views and functions
- Final plan
¶ 4. Pour closure
- What we achieved
- Migrated PostgreSQL DB fully-fledged with data
- Low downtime
- What we could have done better
¶ 5. Q & A
About 韓政璇
A web developer who love to tinker with stuff