Targeted business outcomes
This guide focuses on the following business outcomes:
-
Improved user experience
-
Data compliance requirements fulfilled
-
Reduced storage costs
-
Organized data
Improved user experience
Databases that retain historical data can have sluggish performance because of large tables and indexes. When you archive your historical data, you slim your tables and indexes. This has a direct positive impact on customer-facing API operations that interact with your database.
Data compliance requirements fulfilled
Industries such as financial services, public sector organizations, and healthcare have stringent archival requirements. By archiving application data that resides on your Amazon RDS for MySQL, Amazon RDS for MariaDB, or Aurora MySQL-Compatible database in Amazon S3, you can meet the requirements for regulated compliance, including the following:
-
Payment Card Industry Data Security Standard (PCI DSS)
-
Health Insurance Portability and Accountability Act (HIPAA) and Health Information Technology for Economic and Clinical Health (HITECH) Act
-
Federal Risk and Authorization Management Program (FedRAMP)
-
General Data Protection Regulation (GDPR)
-
Federal Information Processing Standards (FIPS) 140-2
-
National Institute of Standards and Technology (NIST) 800–171
Reduced storage costs
Keeping data in Amazon RDS increases storage cost and requires higher IOPS. If you compare
the cost of storage per GB-month for Amazon RDS for MySQL Multi-AZ GP2us-east-1 AWS Region, the S3 Glacier storage cost is about 57 times lower than
that of Amazon RDS.
Organized data
It's good to keep informative data that will be accessed frequently by application in the database. However, applications generate a large quantity of data that isn't required very often or becomes stale. These records can be archived and kept in place, which is cost-effective and doesn't impact application performance.