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.

10 comments

renewiltord

Reply
sgarland  2 years ago

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.

  • ndriscoll  2 years ago

    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".

  • sroussey  2 years ago

    Most databases expressly say don’t run storage over a network.

    • amluto  2 years ago

      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 →

  • renewiltord  2 years ago

    Yes. We have it 4x striped on those same machines. Burns like lightning.

    • icelancer  2 years ago

      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.

    • sgarland  2 years ago

      The only problem is it hides all of the horrible queries. Ah well, can’t have it all.