Is it more efficient to use AWS s3 versions to store mysql gzipped dumps?

Question

With my database, we take a mysql backup for backup every hour. Then we upload this backup to AWS s3 for security and backup. We use the version to store only the delta of each new backup. My question is, are we really picking something up by loading data first? Does gzip collect data so that all data is re-saved with each version?

If we instead save an uncompressed version of the database, will we actually save time in space due to more efficient version control?

I must add that we keep an hourly backup in s3 for several months using version control. But I can not find in the online interface how to find out how much each new version takes up memory.

Answer 1

You seem to be running S3 snapshots and EBS snapshots. The S3 version does not store the delta, it saves the entire version every time. Creating a backup in which you pay only for the size of the delta is a "Elastic Block" snapshot function.