Multitenant, the Hell of Migrations
summary
A team using Django Tenants Schemas faced very slow migrations across over 3,000 schemas during a major data-structure change, so they modified the migration system to run in parallel (using threads) and cut migration time to less than a third. They are now developing a new approach to run migrations via Celery for higher concurrency and better control, and the talk shares their experience and the solutions they implemented for managing migrations at multitenant scale.
AI-written summary · about
chapters (7)
- 0:00Multitenancy introduction
- 4:25Multiple schemas benefits
- 6:39Multitenant migration challenges
- 10:21Optimization with partial functions
- 12:29Current issues and solutions
- 15:17Future migration improvements
- 17:22Conclusions and recommendations
related talks
25mMultitenant applications: how and why
24mOf Django, PostgreSQL schemas, and your multi-million dollar idea
30mMulti-tenancy strategies with Django+PostgreSQL
25mDeploying Django migrations at Kraken scale with Tim Bell
25mMultitenancy with Rails
57mDjangoCon 2008 Panel: Schema Evolution
26mMultitenant Web Applications with Phoenix
31mSpace Django: Migrating and Redesigning a Database while Hunting for Satellites.