prisma / extension-read-replicas

Prisma Client Extension to add read replica support to your Prisma Client
Apache License 2.0
96 stars 6 forks source link

When AWS Aurora readers scale new instances aren't used #26

Open jakowenko opened 8 months ago

jakowenko commented 8 months ago

Hello, I'm using this package with a Aurora Serverless v2 MySQL database. I have a single writer and readers that scale. I've noticed that when new readers scale up they go unused until I restart the API. I'm guessing it has something to do with the read replica connection not being refreshed.

Sequelize has a maxUses for their pools and they describe the problem pretty well here: https://github.com/sequelize/sequelize-pool#using-maxuses-option. I was hoping for something similar, or guidance on how to use this in an enterprise environment which scales.