0

I've recently increased my General Purpose SSD storage up from 1000Gb to 6000Gb in an accident. Now i'm trying to bring the storage size down to the original 1000Gb but i can't do it over the console.

I also tried taking a snapshot and then allocating a smaller storage size down but once the snapshot is restored it goes back to 6000Gb.

My next option is to backup 900Gb worth of data from my current db and import into a new RDS instance using workbench import sql data (very slow).

Is there something else that i can do to either bring the size down, or a faster way to export and import data from the oversized rds instance to a new smaller instance?

0

First, you should not try to squeeze 900GB of data in only 1000GB of disk. This does not leave room for maintenance. I recommend 2*900 or at least 900 + the size of the largest table.

I don't happen to know how RDS does size changes, but it may be that they take some shortcuts when growing, but cannot use similar shortcuts when shrinking. I suspect they do as much as they can with snapshots of the disk.

Looking at migration in general, there are two main ways:

  • LVM (or similar) Snapshot of disk (as RDS probably does)
  • Dump the data to a file. It includes CREATEs and INSERTs sufficient to rebuild the data from scratch. The dump of 900GB will take more (or less) than 900GB -- depending on datatypes, etc. Such a dump can be done across the network from a tight (eg 1000GB; only 100GB to spare) machine to a machine with more room.

Bottom line: Aim for a 2000GB virtual machine. If that doesn't work easily (via RDS tools), then I hope someone more versed in RDS will chime in.

Another issue... You should probably put your database on an RDS 'server' that is tuned for databases. And put your application on a separate 'server'. They have different needs and can be migrated up or down separately.

3
  • I currently use RDS only for the DBs, the application sits on another server. As for the storage, anything below 6000Gb and above 1000Gb is good enough. Oct 3 at 15:18
  • @benjaminwong - Was "General Purpose" referring to the category of server? Or to the SSD? 1000GB of is not good enough for 900GB of data.
    – Rick James
    Oct 3 at 15:39
  • Yup, there are 3 types, General Purpose, Provisioned Iops and Magnetic. That's okay for the size, we could do 2.5tb even, but 6tb is overkill for now and is eating up my credit card limit hah Oct 3 at 17:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.