TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

How to Run a Database on AWS with Better Performance and Lower Cost

44 pointsby Bella-Xiangover 4 years ago

5 comments

rubiquityover 4 years ago
Disclosure (I used the right word!): I work at AWS. Opinions are my own.<p>This is a nice article with some fun comparisons and important details around the specifics of operating TiDB and systems like it on AWS. If I were running a replicated database such as TiDB, hypothetically of course, I&#x27;d probably opt for an instance type with locally attached storage. EBS volumes are already replicated themselves for durability so if you&#x27;re running a replicated DB on EBS volumes then you&#x27;re going to be replicating while you&#x27;re replicating. Yo dawg. That&#x27;s going to be some extra latency, even with a majority quorum replication protocol like Raft.<p>Historically if you wanted locally attached SSDs the more expensive storage instance types like i2&#x2F;i3&#x2F;i3en were all you had but now there&#x27;s m6gd, c6gd, and r6gd[0]. Lots of options at all sorts of price points for your workload. The Graviton 2 based m6gd instances with local NVMe SSDs are more cost effective than the m5 instances that the blog post is using, which do not have a local SSD.<p>As the post calls out, if you are going to use EBS then use it for the materialized key-value store portion. Maybe even make a little Step Function to snapshot the EBS volumes to figure out where you can safely trim the Raft log at. It could be nice.<p>0 - <a href="https:&#x2F;&#x2F;aws.amazon.com&#x2F;about-aws&#x2F;whats-new&#x2F;2020&#x2F;07&#x2F;announcing-new-amazon-ec2-instances-powered-aws-graviton2-processors&#x2F;" rel="nofollow">https:&#x2F;&#x2F;aws.amazon.com&#x2F;about-aws&#x2F;whats-new&#x2F;2020&#x2F;07&#x2F;announcin...</a>
评论 #25208345 未加载
评论 #25213553 未加载
CharlesWover 4 years ago
A less clickbait-y title would be, &quot;How to Run Our Database on AWS at a Reasonable Cost&quot;.<p>&quot;Reasonable Cost&quot; comes from the conclusion, and I omitted &quot;Better Performance&quot; since they never compare to alternatives (although they do mention Aurora).
评论 #25205903 未加载
评论 #25207290 未加载
jfimover 4 years ago
The part that&#x27;s not mentioned is that there&#x27;s no real latency guarantee on these IOPS. If you&#x27;re running a database that has to do a few data dependent reads (eg. walking a B tree), then these can add up quickly if latency spikes to dozens of milliseconds (eg. this datadog blog post [0]).<p>[0] <a href="https:&#x2F;&#x2F;www.datadoghq.com&#x2F;blog&#x2F;aws-ebs-latency-and-iops-the-surprising-truth&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.datadoghq.com&#x2F;blog&#x2F;aws-ebs-latency-and-iops-the-...</a>
评论 #25206327 未加载
jtdevover 4 years ago
I’m not sure how this could be cheaper than RDS...? Nor do I see how the complexity of this solution could be justified except in the most performance sensitive situations.
评论 #25215551 未加载
pachicoover 4 years ago
I&#x27;m quite surprised, by looking at the post date, they didn&#x27;t use the new Graviton2 instances. I&#x27;m afraid this post is born already obsolete on this matter.
评论 #25205989 未加载