@babysoftluke@kirplatonov We run 1vCPU 3.7 RAM instance, CPU spikes a little over 50%. Jobs I'd say we run currently 240k per day, continuous processing of webhooks plus scheduled jobs every 5 minutes.
@kirplatonov No, we run a single CloudSQL instance on GCP. The same one that powers the rails webapp. Also run on a single Cloudrun instance with 1 vCPU and it's fine for now.
Didn't see the need to invest more in scaling out for now but will become a problem ofc.
@kirplatonov The only thing I noticed is it tends to hammer the database if you have a high number of jobs running, not a problem for now. But I think there's ways to mitigate that by tuning postgres (disabling the WAL on solid queue tables is something I want to try)
@jamesdevonport Used to happen to us too & we've restricted features and have to manually approve them. While annoying, it's good because it gets us talking to more users.
@kevin_miguet @ShopifyDevFazal I used to feel like this, maybe still do sometimes. You're not alone. I think it's useful to realise that those people in the past don't matter. It's probably more powerful visualising yourself in the future being happy😇
@DebMecca True! It's funny because I've spent sometimes so much time with people setting things up for them and when I ask them for a review they stop replying 😂
@DebMecca@liam_at_shopify If you look at this one, it carries similar traits with the other ones we've had to block: https://t.co/Msibj73D7N -- since we're SMS-based, they try to scam people with "delivery missed" scams. You could run a simple ML model on the shop names, maybe other attributes of the shop
@DebMecca We are. Just reported it to Shopify and messaged @liam_at_shopify about it.
Not sure how they are able to sign up, especially with fake email addresses.