The problem with this and other solutions is the cold start mechanism takes 1-2 minutes. The users I was supporting complained that the site never worked.
I ended up just running Ghost in a docker container in a free Google Cloud vm instance to get around the issue with the awesome google drive storage plugin.
I’m super keen to see a solution for this too. I’ve tried setting my minimum instances on CloudRun to 1, so theoretically it should stick around, but even in this configuration GCP will randomly restart an instance if it wants to.
For now I’ll probably go with a VM setup, but it’d be great to get a proper CloudRun/serverless option, especially because if we’re using Ghost as Newsletter site, it’ll be idle for a long time between mail outs.
Log output showing 88 second startup time, even with the database ready to go