Moving archived table data to Amazon S3

Amazon Simple Storage Service (Amazon S3) is the natural target for archived data. It provides 99.999999999 percent durability, and it's less expensive than database storage.

Furthermore, Amazon S3 has built-in storage classes that are priced based on the retrieval pattern. You have the option of transitioning the offloaded S3 objects into a lower-priced storage tier based on the data's retrieval frequency. For more information about storage classes and pricing, see the Amazon S3 documentation.

For applications that use fleets of MySQL instances, offloading into Amazon S3 would mean saving money on data that meets the following criteria:

• Must be archived from the database to increase efficiency

• Isn’t required immediately, or is sparingly needed for any business process

• Must be retained for a long term because of audit requirements

You can archive MySQL data in the following ways:

• Export data from a live Amazon Aurora cluster

• Export data by using SELECT INTO OUTFILE S3

• Export data by using AWS Glue