Hello everyone,
Thank you so much for your comments here. It means a lot.
the limit was still being hit. I ended up configuring the instance to use 1.7 GB of memory (and ensured that the max_connections was 50) and that seems to have solved the problem so far.
Currently exploring the above plan having 2GB, 1vCPU
The plan seems to have 47 backend connections available which I believe should be sufficient.
| Plan Size | Available Backend Connections |
|---|---|
| 2 GB RAM | 47 |
Looks like I can then configure options to be
options: {
pool: {
min: 0,
max: 44,
},
},
as 3 are reserved for maintenance.
There will be less than this number of active users.
I’m not sure how Strapi handles connections and whether it is closing them appropriately once finished?
Did anyone have to setup cross database references?
I also posted a question here on DigitalOcean Question | DigitalOcean