Amazon RDS has launched the ability to shrink storage volumes using Amazon RDS Blue/Green Deployments - a nice addition to the list of new use cases that Blue/Green Deployments now supports.
Blue/Green Deployments create a fully managed staging environment, or Green databases, with your specified storage size, and keep the Blue and Green databases in sync. When you are ready, you can promote the Green databases to be the new production system in as fast as a minute.
Previously, reducing Amazon RDS storage involved manually migrating data to a new database instance with a smaller storage configuration. Some of the common approaches to this migration included logical backup and restore, AWS Database Migration Service (AWS DMS), and native database replication. These methods required manual setup and coordination of the cutover procedures, which was complex and error-prone.
Blue/Green Deployments storage volume shrink, available for Amazon RDS for PostgreSQL major versions 12 and later, RDS for MySQL major versions 5.7 and later, and Amazon RDS for MariaDB major versions 10.4 and later.
For reducing your RDS instance storage using Amazon RDS Blue/Green Deployments, you can create a fully managed staging environment and keep the Blue and Green databases in sync. This simplified approach has more predictable downtime and allows you to increase and decrease your storage volume size based on anticipated application demands.
It is important to consider both storage space and performance requirements, including IOPS and throughput, when rightsizing Amazon RDS database instance storage.
To improve the performance of the storage volume shrink operation, it is worth considering using the best performing io2 Block Express storage when creating the green instance. The baseline IOPS and throughput for your storage volume type and allocated storage are essential for optimal performance.
PostgreSQL vacuum or MySQL purge cleans up space occupied by obsolete data and makes the space available for subsequent operations, minimizing data bloat.
RDS Blue/Green Deployments use PostgreSQL physical streaming or logical replication technology depending on specifications of the green environment.
With Amazon RDS Blue/Green Deployments, you can now scale your storage down post-holidays if needed.