Amazon Aurora allows dynamic resizing of storage space for databases
Amazon Aurora is a relational database engine which combines high-end commercial database speed and reliability with open source database simplicity and cost-effectiveness.
Without making any modifications to most MySQL applications, Amazon Aurora MySQL offers up to five times MySQL efficiency and Amazon Aurora PostgreSQL delivers up to three times PostgreSQL efficiency. At 1/10th the cost, it offers the security, availability, and reliability of commercial databases.
In the cluster volume, which is a single virtual volume that uses solid state drives (SSDs), Aurora data is stored. A cluster volume consists of copies of the data in a single AWS Region across several Availability Zones.
Since the information is replicated automatically across Availability Zones, the data is highly durable with less data loss potential. This replication also means that during a failover the database is more accessible. It does so because in the other Availability Areas, data copies already exist and continue to support data requests to the DB instances in user’s DB cluster. The sum of replication is independent of cluster ‘s number of DB instances according to AWS.
Upon removing data from the cluster, the storage space allocated to user’s Amazon Aurora database cluster will now dynamically decrease.
Disk space is now automatically expanded to a limit of 128 tebibytes (TiB) and is now automatically decreased when data is removed. Users are charged only for the storage they use.
Dynamic storage space resizing became available region-by-region starting on September 21, 2020 for Aurora MySQL versions 1.23 and 2.09, and Aurora PostgreSQL versions 10.13 and 11.8 is planned to be available by the end of November 2020 across all Aurora regions, according to AWS.
Earlier, the total assigned storage space remained the same when user removed data from Aurora clusters, such as by removing a table or partition. This was because if data was added later, the free space was not published in order to be reused automatically. When user remove data with dynamic resizing, the allocated storage space decreases automatically.