Modernizing a megascale database

on YouTube ↗31m

" summary

450 TB system with 150 TB OLTP, 8,000 tables, 4,500 queries and 460 stored procedures migrates using AWS Schema Conversion Tool and DMS extended by DataFury. DataFury automates SQL refactors into Aurora PostgreSQL, profiles data types, runs side by side query unit tests, MD5 table checksums, and produces module level effort estimates. Recovery time target drops from >20 minutes to <2, migration effort claims drop by a third, and 60+ tunings improve performance.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 0:30Scaling the system
3. 1:07Agenda
4. 1:41System Cal
5. 3:20Technology Refresh
6. 4:37Roadmap
7. 9:41Why modernize
8. 15:45Operations
9. 18:09Data Fury
10. 18:32What is Data Fury
11. 22:57Data Validation Data Fury
12. 28:59Recap
13. 30:01Closing remarks
14. 30:18Conclusion

" related talks

• 39mAutomating database migration - Amazon DMS tutorialEran Schitzer · Percona Live Open Source Database Conference 2017
• 37mDatabase Modernization at Cloud Scale: Minimizing Risk and DisruptionRama Chandra Murthy · Distributed SQL Summit Asia 2022
• 25mMigrate to an AWS database: The freedom to save, grow, and innovatePaul Mouradian · AWS AMER Summit May 2021
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 23mCCC Intelligent Solutions Achieves Improved Efficiency with Oracle to AWS PostgreSQLSubrat Mishra · Percona Live 2026 Bay Area
• 21mSave, Grow and Innovate using AWS DatabasesAkanksha Sheoran · Conf42 Cloud Native 2021
• 26mIntroduction to AWS databases: Modernize your data infrastructureBarry Morris, Mike Welch · AWS AMER Summit May 2021
• 42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtimeDmitriy Pogibenko · РИТ++ 2017