Comments on: AWS RDS Backups: What’s the True Cost? https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/ Wed, 28 Sep 2022 12:06:42 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Vitaly Karasik https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973771 Wed, 28 Sep 2022 12:06:42 +0000 https://www.percona.com/blog/?p=82462#comment-10973771 In reply to Renato Losio.

Renato – you’re right, according to my test, snapshots are incremental.

]]> By: Vitaly Karasik https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973770 Wed, 28 Sep 2022 12:05:52 +0000 https://www.percona.com/blog/?p=82462#comment-10973770 In reply to Daniel Guzmán Burgos.

Hi,
According to my tests with AWS MySQL RDS, snapshots are incremental. As far as there are no DB modifications, there are no additional cost for 10 daily snapshots. I launched db.t4g.micro with 25GB storage and paid $0.48/day until I modified DB.

]]> By: Daniel Guzmán Burgos https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973754 Tue, 13 Sep 2022 15:49:07 +0000 https://www.percona.com/blog/?p=82462#comment-10973754 In reply to Vitaly Karasik.

Answers to your questions:

  • Currently not
  • Not directly, only when you do a point in time recovery (PITR)
  • Not that i’m aware of, but you can do that with the “AWS Backup” service
]]> By: Arto Hakola https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973752 Mon, 12 Sep 2022 05:50:40 +0000 https://www.percona.com/blog/?p=82462#comment-10973752 In reply to Renato Losio.

My experience with Aurora is that you have to restore it to a new instance. You cannot restore backup to an existing instance.

]]> By: Renato Losio https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973748 Fri, 09 Sep 2022 17:58:05 +0000 https://www.percona.com/blog/?p=82462#comment-10973748 Good points Daniel, RDS backups can indeed be expensive and there is indeed no clear metric to monitor the sizes.

A couple of notes:

“In other words, this means that one daily snapshot is free. What about the remaining six?”

That is not strictly true as that is the allocated storage (not used storage) and the RDS backups (as all EBS snapshots) are incremental. You can find it in many points in the documentation:

“Furthermore the first snapshot of a DB instance contains the data for the full DB instance. Subsequent snapshots of the same DB instance are incremental, which means that only the data that has changed after your most recent snapshot is saved.”

So have the feeling some of the numbers in the article are on the high side. All that said is not uncommon to see deployments where backup accounts for 30% or more of the overall RDS costs

About “one needs to create a completely new DB instance” that is indeed the case with RDS but not with Aurora, where (interestingly) backup costs (USD/GB) are significantly lower than for RDS.

]]> By: Vitaly Karasik https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comment-10973745 Thu, 08 Sep 2022 12:30:03 +0000 https://www.percona.com/blog/?p=82462#comment-10973745 Thank you, I learned a few new things.
A few questions:

  • Is there a chance that RDS snapshots store only deltas (like EBS snapshots)?
  • “RDS uploads the transaction logs to S3 every five minutes” – do we have access for them?
  • “12 monthly backups” – is there a way to do that with RDS managed backups?
]]>