Comment by renewiltord
2 years ago
You don't get the higher end machines on AWS unless you're a big guy. We have Epyc 9684X on-prem. Cannot match that at the price on AWS. That's just about making the choices. Most companies are not DB-primary.
2 years ago
You don't get the higher end machines on AWS unless you're a big guy. We have Epyc 9684X on-prem. Cannot match that at the price on AWS. That's just about making the choices. Most companies are not DB-primary.
I think most people who’ve never experienced native NVMe for a DB are also unaware of just how blindingly fast it is. Even io2 Block Express isn’t the same.
Funny enough, the easiest way to experience this is probably to do some performance experimentation on the machine you code on. If it's a laptop made in the last few years, the performance you can get out of it knowing that it's sipping on a 45W power brick with probably not great cooling will make you very skeptical of when people talk about "scale".
Most databases expressly say don’t run storage over a network.
To be fair, most networked filesystems are nowhere near as good as EBS. That’s one AWS service that takes real work to replicate on-prem.
OTOH, as noted, EBS does not perform as well as native NVMe and is hilariously expensive if you try. And quite a few use cases are just fine on plain old NVMe.
1 reply →
Yes. We have it 4x striped on those same machines. Burns like lightning.
Ha, I did just the same thing - and also optimized for an extremely fast per-thread CPU (which you never get from managed service providers).
The query times are incredible.
The only problem is it hides all of the horrible queries. Ah well, can’t have it all.
I have one of those. It’s so fast I don’t even know what to do with it.
1 reply →