*Going Fully Serverless: migrating a live Prisma p...
# orm-help
u
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
❤️ 2