RDS database instance should have Auto Minor Version Upgrade enabled

This page is not yet available in Spanish. We are working on its translation.
If you have any questions or feedback about our current translation project, feel free to reach out to us!

Description

Ensure that RDS database instances have the Auto Minor Version Upgrade flag enabled in order to automatically receive minor engine upgrades (features, bug fixes, and security patches) during the specified maintenance window.

Rationale

AWS RDS will occasionally deprecate minor engine versions and provide new ones for an upgrade. When the last version number in the release is replaced, the version change is considered minor. With the Auto Minor Version Upgrade feature enabled, the version upgrades will occur automatically during the specified maintenance window.

Impact

Creation, management, and storage of Customer-Managed Keys (CMKs) may require additional time assistance from an administrator.

Remediation

From the console

  1. Log in to the AWS management console and navigate to the RDS dashboard.
  2. In the left navigation panel, click Databases.
  3. Select the RDS instance that you’d like to update.
  4. Click the Modify button on the upper-right corner of the page.
  5. Locate the Maintenance section of the Modify DB Instance: page, select Auto minor version upgrade, and then click Yes.
  6. At the bottom of the page, click Continue, then select Immediately to apply the changes immediately or Apply during the next scheduled maintenance window to avoid any downtime.
  7. Review the changes and click Modify DB Instance. The instance status should change from available to modifying, and then back to available. Once the feature is enabled, the Auto Minor Version Upgrade status should change to Yes.

From the command line

  1. Run the following command to list all RDS database instances that are available in the selected AWS region:

    aws rds describe-db-instances --region <regionName> --query 'DBInstances[*].DBInstanceIdentifier'
    
  2. Run the following command to modify the selected RDS instance configuration and apply the changes immediately. To avoid downtime, you can remove –apply-immediately to apply the changes during the next scheduled maintenance window:

    aws rds modify-db-instance --region <regionName> \
    --db-instance-identifier <dbInstanceIdentifier> \
    --auto-minor-version-upgrade \
    --apply-immediately
    
  3. The command output returns the new configuration metadata for the RDS instance along with the AutoMinorVersionUpgrade parameter value. To verify that the Auto Minor Version Upgrade feature has been successfully enabled, run the following command:

    aws rds describe-db-instances --region <regionName> \
    --db-instance-identifier <dbInstanceIdentifier> \
    --query 'DBInstances[*].AutoMinorVersionUpgrade'
    

If the command output returns the current status as true, the feature is successfully enabled.

References

  1. Managing an Amazon RDS DB instance
  2. Upgrading a DB instance engine version
  3. Amazon RDS FAQ