Comment by creativesage
Comment by creativesage 4 days ago
Photo culling app. Photographers upload 1000+ images, ML clusters similar shots so clients can pick favorites faster. Needs serious parallel compute (but infrequently). Cloud SQL is the baseline (~$40-50/month, doesn't scale to zero).
My fuckup was setting --cpu 4 --memory 16Gi during initial migration and only optimizing instance counts, not resource sizing.
Didn't help that GCP has no hard spending cap. Budgets only send alerts (in my case 1 easy to miss alert saying you spent more than $50 this month), they don't stop charges... Looking at my credit card statement there are multiple $1-2k charges.
The incentives aren't exactly aligned toward helping you spend less.
> Cloud SQL is the baseline
Does GCP not have something equivalent to Aurora Serverless? [0]
It's more expensive if you are constantly using the database over the course of a month, but much less expensive if you only have bursty traffic.
0: https://aws.amazon.com/rds/aurora/serverless/