Going Fully Serverless: migrating a live Prisma project from MySQL to PlanetScale with zero downtime
In this video, you will learn how to use PlanetScale's import service to migrate from AWS RDS (or any other MySQL instance) to PlanetScale with zero downtime. Daniel will migrate the database of a live Prisma app deployed to Vercel making the app fully serverless. The Prisma Data Platform will also be used to verify the migration and make sure that all data is replicated correctly.
PlanetScale database imports: https://docs.planetscale.com/concepts...
Prisma & PlanetScale open issue: https://github.com/prisma/prisma/issu...
Prisma Data Platform http://cloud.prisma.io/
Source code: https://github.com/2color/ama-prisma
Timestamps:
00:00 : Introduction
00:37 : Exploring the app's source code
01:43 : Adjusting the Prisma schema and setting referential integrity
03:47 : Creating a migration to remove foreign keys
04:40 : Running the migration aginst the Production MySQL on AWS RDS
05:10 : Configuring MySQL for the import into PlanetScale
06:33 : Importing (setting up replication) from MySQL to PlanetScale
08:19 : Adding the PlanetScale DB to the Prisma Data Platform
09:26 : Verifying that replication with the Data Browser in the Prisma Data Platform
10:46 : Updating the environment variable on Vercel
13:55 : PlantetScale specific configuration: removing migration deployments from build process
15:35: Summary
——————————————————
📚 Learn more about Prisma
• Website: https://www.prisma.io
• Docs: https://www.prisma.io/docs
• Quickstart: https://pris.ly/qstart
——————————————————
💬 Connect with Prisma:
Twitter: / prisma
Discord: https://pris.ly/discord
LinkedIn: / prisma-io
——————————————————
✅ Subscribe to Prisma's YouTube channel
/ @prismadata
Watch video Going Fully Serverless: migrating a live Prisma project from MySQL to PlanetScale with zero downtime online without registration, duration hours minute second in high quality. This video was added by user Prisma 29 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,404 once and liked it 29 people.