TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Aurora I/O optimized config saved 90% DB cost

136 点作者 fosterfriends将近 2 年前

15 条评论

ignoramous将近 2 年前
&gt; <i>We reached out to some contacts at AWS to find out why the Aurora team built this. Did I&#x2F;O Optimized do some clever engineering with sharding and storing data in S3? Were they just feeling generous?</i><p>No surprises here. Come what may, Amazon has always strived to lower costs (the low costs, more customers, more volume fly-wheel?). This is but one example.<p>AWS adopted <i>cost-follow</i> pricing for S3 (very different from value-based pricing) after apparently a lengthy debate: As they get more efficient, they want to pass down those savings to customers (as price reductions):<p><pre><code> S3 would be a tiered monthly subscription service based on average storage use, with a free tier. Customers would choose a monthly subscription rate based on how much data they typically needed to store. Simple ... The engineering team was ready to move on to the next question. Except that day we never got to the next question. We kept discussing this question. We really did not know how developers would use S3 when it launched. Would they store mostly large objects with low retrieval rates? Small objects with high retrieval rates? How often would updates happen versus reads? ... All those factors were unknown yet could meaningfully impact our costs ... was there a way to structure our pricing [to] ensure that it would be affordable to our customers and to Amazon? ... the discussion moved away from a tiered subscription pricing strategy and toward a cost-following strategy. &quot;Cost following&quot; means that your pricing model is driven primarily by your costs, which are then passed on to your customer. This is what construction companies use, because building your customer&#x27;s gazebo out of redwood will cost you a lot more than building it out of pine. If we were to use a cost-following strategy, we&#x27;d be sacrificing the simplicity of subscription pricing, but both our customers and Amazon would benefit. With cost following, whatever the developer did with S3, they would use it in a way that would meet their requirements, and they would strive to minimise their cost and, therefore, our cost too. There would be no gaming of the system, and we wouldn&#x27;t have to estimate how the mythical average customer would use S3 to set our prices. </code></pre> From: <a href="https:&#x2F;&#x2F;archive.is&#x2F;lT5zT" rel="nofollow noreferrer">https:&#x2F;&#x2F;archive.is&#x2F;lT5zT</a><p>I wonder what explains AWS&#x27; high egress costs, though.
评论 #37081189 未加载
评论 #37082036 未加载
评论 #37082588 未加载
评论 #37086182 未加载
评论 #37086536 未加载
timbaboon将近 2 年前
I work for a large insurance company. We had moved from on-prem to Aurora, but our design strategy did not get updated in the process, and our IO costs were about 80% of our total AWS bill. We just switched to this new IO optimised pricing and we’re seeing huge discounts. I can sleep a bit easier now :) (we still are going to change our DB design to reduce IO anyway)
nusmella将近 2 年前
We have a 10TB database we switched from Aurora to Postgres and it cut out bill by 80%. However, there are some differences in our schema such as now using native partitions so it&#x27;s hard to tell how much $ is due to the switch and how much due to our table and query design.<p>We have a similar story with DynamoDB too.
评论 #37083683 未加载
评论 #37084021 未加载
评论 #37083190 未加载
评论 #37089343 未加载
BrentOzar将近 2 年前
Cut ours by over 40% too: <a href="https:&#x2F;&#x2F;www.brentozar.com&#x2F;archive&#x2F;2023&#x2F;06&#x2F;aws-aurora-cut-our-database-costs-for-sql-constantcare-again&#x2F;" rel="nofollow noreferrer">https:&#x2F;&#x2F;www.brentozar.com&#x2F;archive&#x2F;2023&#x2F;06&#x2F;aws-aurora-cut-our...</a>
评论 #37080987 未加载
bearjaws将近 2 年前
I highly recommend communicating with your business support team at AWS.<p>Mine have always been helpful and have kept us up to date on releases like this, sometimes we even get them before they are GA.
belter将近 2 年前
Maybe good to review the technical details around the feature. You might want to have a look at the blog in the last reference, and the sanity check Lambda script, before switching. Or also this specific timestamp in the presentation linked below: <a href="https:&#x2F;&#x2F;youtu.be&#x2F;FBZmxLm0Bhw?t=355" rel="nofollow noreferrer">https:&#x2F;&#x2F;youtu.be&#x2F;FBZmxLm0Bhw?t=355</a><p>&quot;AWS announces Amazon Aurora I&#x2F;O-Optimized&quot; - <a href="https:&#x2F;&#x2F;aws.amazon.com&#x2F;about-aws&#x2F;whats-new&#x2F;2023&#x2F;05&#x2F;amazon-aurora-i-o-optimized&#x2F;" rel="nofollow noreferrer">https:&#x2F;&#x2F;aws.amazon.com&#x2F;about-aws&#x2F;whats-new&#x2F;2023&#x2F;05&#x2F;amazon-au...</a><p>&quot;New – Amazon Aurora I&#x2F;O-Optimized Cluster Configuration with Up to 40% Cost Savings for I&#x2F;O-Intensive Applications&quot; - <a href="https:&#x2F;&#x2F;aws.amazon.com&#x2F;blogs&#x2F;aws&#x2F;new-amazon-aurora-i-o-optimized-cluster-configuration-with-up-to-40-cost-savings-for-i-o-intensive-applications&#x2F;" rel="nofollow noreferrer">https:&#x2F;&#x2F;aws.amazon.com&#x2F;blogs&#x2F;aws&#x2F;new-amazon-aurora-i-o-optim...</a><p>&quot;Getting Started with Amazon Aurora I&#x2F;O-Optimized&quot; - <a href="https:&#x2F;&#x2F;youtu.be&#x2F;OlFeaVd6Ll4" rel="nofollow noreferrer">https:&#x2F;&#x2F;youtu.be&#x2F;OlFeaVd6Ll4</a><p>&quot;AWS On Air ft. Introducing Amazon Aurora I&#x2F;O Optimized&quot; - <a href="https:&#x2F;&#x2F;youtu.be&#x2F;FBZmxLm0Bhw" rel="nofollow noreferrer">https:&#x2F;&#x2F;youtu.be&#x2F;FBZmxLm0Bhw</a><p>&quot;AWS Aurora IO Optimized Storage — Is it worth it?&quot; - <a href="https:&#x2F;&#x2F;towardsaws.com&#x2F;aws-aurora-io-optimized-storage-is-it-worth-it-b099dce558c8" rel="nofollow noreferrer">https:&#x2F;&#x2F;towardsaws.com&#x2F;aws-aurora-io-optimized-storage-is-it...</a>
jjice将近 2 年前
I didn&#x27;t know about Aurora IO Optimized until just now. That solves my biggest fear of Aurora which is an optimized query wreaking havoc on our IO and racking up a bill. Very cool offering to see.
thecarissa将近 2 年前
Greg earned a new espresso machine for his efforts here!
评论 #37081899 未加载
pbowyer将近 2 年前
Where can you see how much of your Aurora spend is on I&#x2F;O? There must be a Cloudwatch metric somewhere
评论 #37081004 未加载
评论 #37082273 未加载
评论 #37084812 未加载
femiagbabiaka将近 2 年前
Wow, good on AWS for releasing such a useful feature. It does feel a little uncomfortable to have to wait on an interested party to make optimizations to benefit you (to the tune of 90% cost savings!!), but I guess that&#x27;s the name of the game in public cloud.
zuckerborg0101将近 2 年前
I wished I knew about this!! Migrating my Aurora clusters rn
aiunboxed将近 2 年前
I am an existing aurora customer and for me also aurora is already contributing to 33% of the cost, while the team is working on optimising pgsql queries, this is a great hope. I hope xmas come early for us as well :)
zgluck将近 2 年前
Does anyone have any experiences to share about the performance differences between regular RDS&#x2F;MySQL and Aurora for MySQL (I&#x2F;O optimized config)?<p>(The article is about the PostgreSQL variant.)
akokanka将近 2 年前
It&#x27;s so amazing when CTO cares about technology and not only shareholders return and gains.
评论 #37082419 未加载
评论 #37083627 未加载
immibis将近 2 年前
Customer buys cloud service with unpredictable pricing. Gets bitten by high prices. Switches to (new!) cloud service with predictable pricing. Prices are lower.<p>Also, it sounds like they could save money by not using cloud.
评论 #37082822 未加载
评论 #37082470 未加载
评论 #37082722 未加载