Hi all — I’m hosting a Next.js app on Vercel with Prisma + MySQL.
My MySQL is on a FreeBSD server in Hetzner. Vercel doesn’t provide fixed outbound IPs on my plan, and Hetzner/MySQL can’t safely allowlist dynamic IPs. I tried running Prisma on FreeBSD, but Prisma engines aren’t available for FreeBSD 14, so prisma generate fails with a 404 for the engine binaries.
What’s the recommended/cleanest setup for this kind of deployment? Any gotchas or alternative approaches?
I’d recommend going down the Static IPs route as it’s the cleanest setup, they provide consistent, fixed IP addresses for all outbound traffic from your Vercel deployment. This solves the IP whitelisting challenge since Vercel normally uses dynamic IPs.