Download to read offline
Uploaded byGiulio Vian
Database deployments - dotnetsheff
The document discusses database deployment strategies, contrasting migration-based and state-based approaches while emphasizing the importance of handling conflicts and dependencies during deployments. It highlights tools like SSDT, Redgate SQL Compare, Flyway, and DBUP, providing references for further reading. The author, Giulio Vian, underscores that careful planning and knowledge are crucial to navigate the complexities of database refactoring.
Database deployments - dotnetsheff
- 1. Database deployments Giulio Vian— 3 March 2021
- 2. In a Start-upfar far away DBA Senior Dev Scrum Master Junior Dev
- 3. Free! too good tobe true • 0 $/£/€ = gratis! • open source • any DB! • 1,400 stars • and works!
- 4. Months pass It’s Friday: Let’s deploythe latest version!
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14. Diff script fromschema-based tool uh oh
- 15.
- 16. Migration based v1 v2 Hides conflicts Order matters State based v1 v2 Miss object renames Rollback drifts Schema evolution
- 17. Migration based v1 v2 State based v1 v2 What to use
- 18. Your path youmust decide
- 19. Are the twomutually exclusive? No Dev can use a Schema diff tool like SSDT to draft migration scripts Migration script can be augmented stating the baseline version State-based tools have pre- and post-deploy phases for data migration We can add dependency check between migration scripts To warn about scripts interaction and dependency
- 20. Hardware spec: 1 KBRAM (16KB after upgrade) 4 KB ROM (8KB after upgrade) First computer Past Companies Communities Giulio Vian Senior DevOps Engineer @giulio_vian giuliovdev@hotmail.com
- 21. References Tools SQL Server DataTools (SSDT) RedGate SQL Compare devart Flyway dbup dbdeploy.net Articles https://en.wikipedia.org/wiki/Sc hema_migration https://martinfowler.com/article s/evodb.html https://michaeljswart.com/2018 /01/100-online-deployments http://blog.dixo.net/2015/02/bl ue-turquoise-green-deployment Books Refactoring Databases: Evolutionary Database Design http://www.agiledata.org/
- 22.
- 23.
- 24. Database Refactoring Cycle Initialstate Final state Implement the refactoring Test on non-production Refactoring completed deploy new schema, migrate data deploy new application version
- 25. Database Refactoring Cycle Initialstate Final state Implement the refactoring Test on non-production Refactoring completed deploy new schema, migrate data deploy new application version
- 26. Database Refactoring Cycle Initialstate Final state Transitional state Implement the refactoring Test on non-production Refactoring completed All systems use the new schema Coexistence of old and new schema Expand: deploy new schema, migrate data, add scaffolding code Contract: Drop old schema objects and scaffolding code
- 27.
- 28.
- 29. La morale Tools are limited Knowyour stuff is the only way Discipline
- 30. Migration troubles with DbUp alsoFlyWay, Liquibase, etc.
- 31.
Editor's Notes
- #7 Source https://www.red-gate.com/hub/product-learning/sql-source-control/moving-from-application-automation-to-true-devops-by-including-the-database
- #8 Source http://workingwithdevs.com/delivering-databases-migrations-vs-state/
- #9 Source http://workingwithdevs.com/delivering-databases-migrations-vs-state/
- #12 Source https://www.red-gate.com/hub/product-learning/sql-source-control/moving-from-application-automation-to-true-devops-by-including-the-database
- #13 Source http://workingwithdevs.com/delivering-databases-migrations-vs-state/
- #14 Source http://workingwithdevs.com/delivering-databases-migrations-vs-state/
- #15 Source http://workingwithdevs.com/delivering-databases-migrations-vs-state/
- #22 10,000+ employees (1,000+ in IT) ~$12 billion Revenue
- #23 https://github.com/facebookincubator/OnlineSchemaChange https://www.percona.com/doc/percona-toolkit/3.0/pt-online-schema-change.html https://octopus.com/blog/databases-with-blue-green-deployments https://www.linkedin.com/pulse/blue-green-deployment-aws-database-synchronisation-james-chan
- #31 Giovanni Francesco Barbieri detto il Guercino (1591-1666) Atlante che sostiene il globo celeste, 1646 Firenze, Museo Mozzi Bardini, inv. MCF-MB 1922-1148.a Il mito del titano Atlante condannato da Zeus a sorreggere la volta celeste per l’eternità ebbe notevole fortuna iconografica nel corso del Seicento. Tra le opere più famose è questa versione, dipinta per Lorenzo de’ Medici.