027: Migrating a Rails Monolith from MySQL to Trilogy with Adrianna Chang

The Rails Changelog

In this episode, I sit down with a seasoned Rails engineer to dive into the technical intricacies and community-building work that power the Ruby ecosystem. Adrianna, who currently works as an engineer at Shopify shares insights into their role, their experience with the vibrant WNB.rb community, and what goes into organising meetups focused on all things Ruby and Rails.

We take a deep dive into Trilogy, Shopify’s custom implementation of the MySQL protocol. Adrianna unpacks the motivation behind developing Trilogy, the design choices that distinguish it from the traditional libmysqlclient library, and the trade-offs they faced. We also discuss the challenges of migrating from MySQL 2 to Trilogy, particularly around compatibility and maintaining a seamless CI/CD pipeline throughout the process.

Listeners will learn about the performance benefits Trilogy offers, how Shopify overcame the obstacles of database migration, and the future roadmap for Trilogy’s development in Rails. Finally, Adrianna reflects on the books that have been instrumental in shaping their career, offering valuable recommendations for developers at all levels.

Try Mailtrap for free
Migrating Shopify’s Core Rails Monolith to Trilogy - Rails World 2023
Trilogy
WNB.rb