← Previous · All Episodes · Next →
027: Migrating a Rails Monolith from MySQL to Trilogy with Adrianna Chang Episode 27

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

· 52:50

|
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


Creators and Guests

Emmanuel Hayford
Host
Emmanuel Hayford
Ruby, Rails. Boxing, chess. Podcasting @railschangelog. Rad Ruby @radrubydev. ⚡️ Rails tips weekly. This Week In Rails co-editor.
Adrianna Chang
Guest
Adrianna Chang
Rails Infra @shopify | @Carleton_U Grad | Dev Degree Alum 🍁 I like hiking, food, and taking naps with my pup 🐶

Subscribe

Listen to The Rails Changelog using one of many popular podcasting apps or directories.

Apple Podcasts Spotify Overcast Pocket Casts Amazon Music YouTube
← Previous · All Episodes · Next →