Hi team, can multiple prisma containers connect to same database. For high availability purposes we have 5 servers. We want to know if all can connect to a single host with MySQL. If not, is there a way to achieve that ?

Same question 😄

I found this issue while trying what you say: https://github.com/prisma/prisma/issues/3306 However, it can be some unrelated issue that just came up randomly 🤷‍♂️

It's kind of same as my issue

I didn’t try it again, but I think adding

PRISMA_MANAGEMENT_API_SECRET

to the .env file as mentioned in https://github.com/prisma/prisma/issues/4069 (very similar issue) might work

But we are not manually deploying prisma. Rather we are using CI for deployment

Same here, but the error is the same. I have a

.env

file and my CI is reading that as well, so I had to add

PRISMA_MANAGEMENT_API_SECRET

variable to make it work. But looks like that is not happening to every body 🤷‍♂️

Since am using an older version of prisma , it's not occuring, rather exclusive lock is preventing other prisma containers to fail

This might help? https://github.com/prisma/prisma/issues/2850

But we have 5 prisma containers running on 5 different hosts. not on the same host