4 ms·
I also know people that spend 40k euro a month to run the database of their rails app on the biggest instance they can find on aws. The traffic is seasonal and
by DrDroop 3y ago
I also know people that spend 40k euro a month to run the database of their rails app on the biggest instance they can find on aws. The traffic is seasonal and the workload is mostly one way payment traffic. But hey, they are still making money so good for them. I've personally been exploring a more flexible architecture for another project using a combination of cloudflare workers, storage and k/v store. The hardest thing about it currently is that you have to engineer everything yourself to be specific to your problem. Either way, both monolith and microservices have their challenges, I hope to find something that can avoid both but it feels like a stab in the dark.
- sjducb 3y agoI’ve had contracting gigs bringing down the costs of SQL DBs that cost a million per year. You can usually get costs below 200k fairly easily. - Performance tuning - Migrate old data out of the DB - Delete unused indexes - Improve queries so they return less unnecessary data The problem is usually one massive table or 2-3 unoptimised queries. No need to rewrite the application to use NoSQL With seasonal load in AWS it’s really easy to change the DB instance size manually. No need for auto scaling.