Hi team, can multiple prisma containers connect to...
# orm-help
o
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 ?
b
Same question 😄
f
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 🤷‍♂️
o
It's kind of same as my issue
f
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
o
But we are not manually deploying prisma. Rather we are using CI for deployment
f
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 🤷‍♂️
o
Since am using an older version of prisma , it's not occuring, rather exclusive lock is preventing other prisma containers to fail
s
o
But we have 5 prisma containers running on 5 different hosts. not on the same host