Right now we’re running Strapi on a Render Node Pro Plan (4GB RAM, CPU 2), and MariaDB on a Render Docker Standard Plan (2GB RAM, CPU 1).
I think when we were on Render Hosted PostgreSQL I tried go up to 8GB RAM, but would still run in the Knex issues… I found some post saying they’ve tried with higher spec’d machines, but the problem was still happening, so probably unrelated.
Also you can’t downgrade I think, at least for the database. So no chance to try a more powerful database machine, run the automatic migration, then take it to a lower spec.
We’re still with render.com with MariaDB (Dockerized). No more Knex issue, but still the deploy fails often with the ER_DUP_KEYNAME: Duplicate key error. In fact we’ve been delaying launching our strapi powered frontend few weeks just because of all these deployment issues… Haven’t figure out all these quirks yet sadly.