Slug: using-multiple-databases-for-data-migrations
Title: Using Multiple Databases for Data Migrations
Speakers:
Event: Meetup 2023-11-09
Position: 1
How we used Active Record with multiple databases to migrate a single-tenant application to a multi-tenant world.
About our speaker:
Oliver Prater is a Software Engineer at Xempus.
Resources:
I added the three architecture diagrams from the presentation that show the current state, the goal state, and the state during migration to the photos.
The link that explains the gotcha's around transactions with multiple databases is https://guillermoap.medium.com/rails-multiple-databases-gotchas-a9fddbd5f545
The post from Tenderlove that I referenced: https://tenderlovemaking.com/2011/10/20/connection-management-in-activerecord.html
A more playful blog post on the topic with a fourth dimensional database is https://www.thegreatcodeadventure.com/managing-multiple-databases-in-a-single-rails-application/
Slides url:
Kind: talk
Announced on:
Language: English