One of the more unique and complicated areas of devops is dealing with database updates, especially those for databases with pre-defined schemas like relational databases. Databases generally:
- Need to stay online during updates
- Should not be destroyed and re-created
- Frequently have changes that can be long running and have impacts to the running application code
- Have implied or explicit dependencies between the database schema and application code or across shards in a sharded database
- Still have the same requirements as application code for being traceably updated
- And should be updated in an automated fashion as part of your devops strategy
This talk will cover tools and strategies the speaker has identified in over 15 years of working with automated database migrations for making sure your persistence stores are smoothly integrated into your devops workflow. We will cover:
- Handling database updates via database migration tools: how to get started and what in the speaker's experience is and is not important in a good migration tool
- Patterns, and tips and tricks, for addressing common issues with database migrations
- Workflow processes for developers, DBAs, and operations teams that enable a smooth, controlled database migration process as part of devops
- How automating your database migrations benefits database administrators
Popular Podcasts
Crime Junkie
Does hearing about a true crime case always leave you scouring the internet for the truth behind the story? Dive into your next mystery with Crime Junkie. Every Monday, join your host Ashley Flowers as she unravels all the details of infamous and underreported true crime cases with her best friend Brit Prawat. From cold cases to missing persons and heroes in our community who seek justice, Crime Junkie is your destination for theories and stories you won’t hear anywhere else. Whether you're a seasoned true crime enthusiast or new to the genre, you'll find yourself on the edge of your seat awaiting a new episode every Monday. If you can never get enough true crime... Congratulations, you’ve found your people. Follow to join a community of Crime Junkies! Crime Junkie is presented by audiochuck Media Company.
24/7 News: The Latest
The latest news in 4 minutes updated every hour, every day.
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.