Making Database Changes Safe and Fast

by Alex Ives | at Minnebar 17

This talk will focus on our efforts to ensure safe and efficient changes to our postgres database at GitLab. In 2018 we implemented a database review process after encountering production incidents caused by bad migrations and poorly performing queries. Over the past 4.5 years, we've have refined this process and developed various tools for automated testing. I'll cover the importance of database review in preventing incidents, as well as the development of the automated migration testing tool. I'll also discuss our plans for further automation in the future. This talk may be relevant to anyone interested in observability, automation, or database management.

Some Links - Our Database Review Process - Automated Migration Testing - Query Intercepter - Blueprint for Automated Query Analysis - Database Group

Intermediate

Alex Ives

I manage the Database group at GitLab where we're building (mostly) internal tooling to help our team deliver database changes faster and more safely.

You can learn more about me on my website.