透過 AWS SCT 與 DMS 從 MySQL 微痛移植到 PostgreSQL
韓政璇
Agenda
1. Intro
- Who
- Why
- What (will & will NOT be included in the talk)
2. Intro - AWS
3. How we approached the migration
- Context
- What
- 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
- How - initial plannings
- 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
PostgreSQL, Create your own DATABASE
TR310-1