MySQL Continuous Database Delivery with Flyway
Delivering database changes pose a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. In this course, you'll learn how to use Flyway to version changes to a MySQL database. You'll also learn how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.
What you'll learn
Continuous Delivery can dramatically decrease turn-around time between customer need and delivered software to fulfill that need. Combining discipline with the right practices and tools leads to early feedback about potential problems, a system of safety nets, the highest level of accountability, and an overall boost in confidence when releasing software. Delivering database changes poses a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. This leads to delays and a lack of realizing the full potential of Continuous Delivery. In this course, you'll learn the fundamentals to make managing database change a breeze and how to make it a first class citizen in your Continuous Delivery pipeline. You'll learn how to use Flyway to version changes to a MySQL database. You'll also learn how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.
Table of contents
- Introduction 1m
- Tracking and Applying Changes 4m
- Introducing Flyway 4m
- How We're Going to Build a New Payroll DB. 3m
- Setting up MySQL Locally for a Dedicated Development DB 3m
- Downloading Flyway 2m
- Creating a Payroll DB 9m
- Adding a First Employee Table 7m
- How to Name Change Scripts 4m
- Adding a Second Titles Table 3m
- Dropping and Recreating Dev DBs at the Push of a Button 2m
- Adding Table Relationships with Employee Titles 4m
- Adding an Employee Positions View 3m
- Recap 2m
- Introduction 4m
- An Overview of CI and Database Changes 5m
- Setting up TeamCity to Test Changes 9m
- Setting up TeamCity to Automatically Kick Off Testing 9m
- The Sky's the Limit of What You Can Test in CI 2m
- Pretesting a Database Release 5m
- Using TeamCity to Pretest the Release and Capture Timing Info 12m
- Recap 1m
- Introduction 1m
- A Transition Strategy 6m
- What We're Going to Do in This Module 3m
- Setting up a Dev and Prod Sakila Database 6m
- Baselining the Sakila Database 9m
- Alignment Strategies 3m
- Aligning Development to Production 3m
- Writing Change Scripts 2m
- Marking Dev as v2 4m
- Marking Prod as v1 4m
- Migrating Production to v2 2m
- Detecting Drift in Production 3m
- Recap 1m
About the author
Wes Higbee is passionate about helping companies achieve remarkable results with technology and software. He’s had extensive experience developing software and working with teams to improve how software is developed to meet business objectives. Wes launched Full City Tech to leverage his expertise to help companies delight customers. Although his primary focus is on outcomes, implementation often includes technical competency. Wes frequently speaks about impactful aspects of software developm... more