Home icon

Reduce Amazon Aurora MySQL backup costs using MySQL Shell and Amazon S3

Database Blog



This article discusses how to reduce the cost of long-term backups for Amazon Aurora MySQL databases by using MySQL Shell and Amazon S3, combined with S3 Glacier for long-term archiving.

Specifically, the article covers:

  • Overview of the solution architecture using MySQL Shell, Amazon S3, and S3 Glacier
  • Prerequisites and steps to install MySQL Shell on Linux, Windows, and macOS
  • How to use MySQL Shell to compress and upload database backups to Amazon S3
  • Configuring S3 lifecycle policies to move backups to S3 Glacier for long-term archiving
  • Restoring backups from S3 Glacier to Amazon S3, and then to an Aurora MySQL instance
  • Cost comparison between using this solution vs. Aurora snapshots for long-term backup retention
  • Cleanup steps to delete the resources created for testing


Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jul 2
2024
Understanding Amazon Aurora MySQL storage space utilization
Jun 23
2025
Migrate a self-managed MySQL database to Amazon Aurora MySQL using AWS DMS homogeneous data migrations
Mar 23
2026
Extract data from Amazon Aurora MySQL to Amazon S3 Tables in Apache Iceberg format
Mar 11
2026
Migrate Cloud SQL for MySQL to Amazon Aurora and Amazon RDS for MySQL Using AWS DMS

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.