Does mid six figure mean ~$500k?
That sounds insane for a crud app with one million users.
What am I missing?
That sounds insane for a crud app with one million users.
What am I missing?
People just throw more compute power (ie money) at performance problems, rather than fixing their queries or making better use of indices.
I’ve contended for a long time that ORMs and their ilk automatically building queries is an antipattern for anything but small data scale. At any reasonable size of db, you’re going to need to know sql well enough to write optimized queries anyway. There’s essential complexity in the DB queries, which ORMs can only hide for so long.
Technically you’ll need a third server to perform the failover, but it doesn’t need to be nearly as big, as it’s just watching heartbeats and issuing commands.
Bare metal is absolutely where it’s at for base infrastructure and bang-for-you-buck.
People call me a graybeard for such things, but it’s never been said derisively or sarcastically to my face. Usually it’s asking for advice.
I took a “traditional” path here. I started when “the cloud” was just the fluffy white cloud that said “Internet” or “Other Networks” at the top of the diagram.
Directly to your point though, I once encountered a salesperson who was running an entire sandbox environment of a very large platform to the tune of about $25k/mo. It sat idle for almost half a year before someone came knocking. The cloud team did an audit and they were a little spicy about it, understandably.