Continuous Delivery for DBAs

Database Administration
3 April 4:30PM - 5:20PM @ Ballroom F

Experience level: 
50 minutes conference
Continuous Delivery has become a best practice for automating and improving the process of software delivery. Automated testing, continuous integration and continuous deployment are mandatory skills for releasing software rapidly with minimal risk and optimal recoverability. The process of managing change in database environments has proven to be a challenge, causing lag in organizations' ability to reach optimal change velocity. In this discussion, Jay Edwards will discuss concepts, approaches and real world techniques for supporting continuous delivery at the database tier, with a focus on MySQL. * Overview of continuous delivery concepts. * DBAs in DevOps cultures. How to drive value and velocity at the database tier. * Versioning Schemas and DB changes * Determination and classification of change impacts via automation and rules based approach. * Testing change in addition to functionality - acceptance, reversion and impact evaluation. * Pushing often, and in batches. * Managing significant changes quickly, easily and with managed task via online schema changes. * Architectural patterns for automated rolling fail overs to support exceptionally significant change.


CTO, Blackbird, (formerly PalominoDB)
Jay was the first dedicated DBA at Twitter. He later served as the lead database engineer at Obama for America during the 2012 election. Currently, he's the CTO for Blackbird, (formerly PalominoDB), a boutique database consulting firm.