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
May 28
2024
Create a fallback migration plan for your self-managed MySQL database to Amazon Aurora MySQL using native bi-directional binary log replication
May 10
2024
Integrate Amazon Aurora MySQL and Amazon Bedrock using SQL
Apr 11
2024
Optimizing AWS Backup costs

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.