You Version Your Code, Why Not Your Database?

@DerekB_WI 1 You Version Your Code,  Why Not Your Database?
Presented By: Derek Binkley

@DerekB_WI 2 Database Administrator Data was king Changes Strictly Managed
Data Access set in RDBMS

@DerekB_WI 3

@DerekB_WI 4 Developers Take Over Sprints instead of waterfalls Rebellion
Against Relational Data

@DerekB_WI 5 Faster Changing Data MySQL, Postgres, etc. Non Relational
Databases

@DerekB_WI 6

@DerekB_WI 7 Relational Data Still Important

@DerekB_WI 8 Version Control Tools Managing Change

@DerekB_WI 9 CI/CD Continuous Integration and Deployments Increase Reliability

@DerekB_WI 10 Manually Changing Data Structures Roadblock to CI/CD

@DerekB_WI 11 NPM Packages such as db-migrate available for Node
Doctrine PHP based database tools, includes migrations LARAVEL Migrations built into PHP framework PHINX PHP Any framework FLYWAY Java, Maven, Gradle LIQUIBASE Java DATABASE VERSIONING

@DerekB_WI 12 Change Set Define multiple changes XML Changelog

@DerekB_WI 13 Prerequisites Snake Yaml https://bitbucket.org/asomov/snakeyaml/src/default/ YAML Changelog

@DerekB_WI 14 Prerequisites Snake Yaml https://bitbucket.org/asomov/snakeyaml/src/default/ JSON Changelog

@DerekB_WI 15 Create Table

@DerekB_WI 16 Alter Table

@DerekB_WI 17 Add an Index

@DerekB_WI 18 Add a Foreign Key

@DerekB_WI 19 liquibase.properties

@DerekB_WI 20 Apply the Changes

@DerekB_WI 21 Is This Any Better than just SQL?

@DerekB_WI 22 Liquibase Tracks Change Sets

@DerekB_WI 23 Instant Setup Code, plus database from git Database
Defined Your migrations completely define your database. Really? Can it capture everything for us?

@DerekB_WI 24 1. Generate Full Change Log

@DerekB_WI 25 2. Setup Data

@DerekB_WI 26 3. Combine Changes

@DerekB_WI 27 Check Out and Build . . .

@DerekB_WI 28 Code Changes We may have modified the database
Keep Track of DDL? Over the course of a feature build you may not have kept an accurate change file

@DerekB_WI 29 Diffs to the rescue

@DerekB_WI 30 Diff Changelog

@DerekB_WI 31 Clear History of Changes

@DerekB_WI 32 Demo Time

@DerekB_WI 33 Rolling Back

@DerekB_WI 34 Prevent Automatic Rollback

@DerekB_WI 35 Rollback to Tag

@DerekB_WI 36 Generating SQL Alternative to Liquibase making changes for
you.

@DerekB_WI 37 Generating SQL

@DerekB_WI 38 AWS Maven Ant Spring Liquibase can integrate with
common build tools or frameworks Workflow Integration

@DerekB_WI 39 Direct Access Deployment Server can contact Database Deployment
Server Deployment could be running directly from deployment machine Deployment Scenario 2 3 1

@DerekB_WI 40 Firewall Blocked Deployment Server cannot access database App
Server Deployment sends message to application server to run migration Deployment Scenario

@DerekB_WI 41 Multiple Deployment Targets

@DerekB_WI 42 Other Changes addAutoIncrement addColumn addDefaultValue addForeignKeyConstraint addLookupTable addNotNullConstraint
addPrimaryKey addUniqueConstraint alterSequence createIndex createProcedure createSequence createTable createView customChange delete dropAllForeignKeyConstraints dropIndex dropNotNullConstraint dropPrimaryKey dropProcedure dropSequence dropTable dropUniqueConstraint dropView empty executeCommand insert loadData loadUpdateData mergeColumns modifyDataType output renameColumn renameTable renameView setColumnRemarks setTableRemarks sql sqlFile stop tagDatabase update

@DerekB_WI 43

@DerekB_WI 44 Derek Binkley [email protected] @DerekB_WI Keep In Touch

@DerekB_WI 45 https://aws.amazon.com/blogs/devops/database-continuous-integration-and- automated-release-management-workflow-with-aws-and-datical-db/ RESOURCES http://www.liquibase.org/tutorial-using-oracle https://youtu.be/m6uNyezQ-7s - integrate Liquibase
and Hibernate https://www.liquibase.org/bestpractices.html https://bitbucket.org/asomov/snakeyaml/src/default/

@DerekB_WI 46 Download Slides

You Version Your Code, Why Not Your Database?

You Version Your Code, Why Not Your Database?

More Decks by derek-b

Other Decks in Technology

Featured

Transcript