Going Fully Serverless: migrating a live Prisma project from MySQL to PlanetScale with zero downtime
https://www.youtube.com/watch?v=hPa2UaLV5jU▾
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/database-imports
Prisma & PlanetScale open issue: https://github.com/prisma/prisma/issues/7292
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
1535 Summary