Sample Header Ad - 728x90

How to down size the storage of AWS RDS MySQL instance?

0 votes
2 answers
411 views
I have an RDS MySQL instance db.m5.4xlarge with 8.3TB of data, and I want to shrink it to 4TB to save costs because it actually has 4TB of data. What are the viable options? I've tried several methods, aiming to complete it within 8 hours: 1. DMS (Database Migration Service): When using DMS, there were index issues. Before the migration, adding indexes caused it to report duplicate IDs, but I checked and couldn't find any duplicates. After the migration, if I add the indexes back, the data doesn't sync. 2. Mysqldump: It takes too long. For 450GB, it's already taking nearly 6 hours. 3. Take Snapshot and restore to smaller storage: but the options on AWS console restrict me to downsize to a volume that is smaller than its original size[enter image description here](https://i.sstatic.net/kEyNI6ib.png)
Asked by user26127523 (11 rep)
Jul 6, 2024, 07:06 AM
Last activity: Aug 2, 2025, 02:02 AM