๐ก๏ธ AWS RDS Instance Auto Minor Version Upgrade is not enabled๐ ๐ข
- Contextual name: ๐ก๏ธ Instance Auto Minor Version Upgrade is not enabled๐ ๐ข
- ID:
/ce/ca/aws/rds/instance-auto-minor-version-upgrade - Tags:
- ๐ข Policy with categories
- ๐ Policy with internal.md
- ๐ข Policy with type
- ๐ข Production policy
- Policy Type:
COMPLIANCE_POLICY - Policy Categories:
RELIABILITY
Logicโ
- ๐ง prod.logic.yaml๐ข
Similar Policiesโ
- AWS Security Hub: [RDS.13] RDS automatic minor version upgrades should be enabled
- Cloud Conformity: RDS Auto Minor Version Upgrade
- Internal:
dec-x-215302da
Similar Internal Rulesโ
| Rule | Policies | Flags |
|---|---|---|
| โ๏ธ dec-x-215302da | 1 |
Internal Notes ๐ โ
Notesโ
For some reason, similar policies mention only
mysqlandpostgresengines in the policyauditandremediationsections. However, AWS documentation tells thatAutoMinorVersionUpgradeattribute is supported onALLDB engines: docsWe've modified the
sshcommands to include all engines (see remediation.md).Our policy document also accepts all engines (doesn't filter any).
Descriptionโ
Descriptionโ
Ensure that RDS database instances have the Auto Minor Version Upgrade flag enabled to receive minor engine upgrades automatically during the specified maintenance window. This allows RDS instances to get new features, bug fixes, and security patches for their database engines.
Rationaleโ
AWS RDS will occasionally deprecate minor engine versions and provide new ones for an upgrade. When the last version number within the release is replaced, the version change is considered minor. With the Auto Minor Version Upgrade feature enabled, upgrades occur automatically during the specified maintenance window so your RDS instances can get new features, bug fixes, and security patches for their database engines.
Auditโ
From Consoleโ
- Log in to the AWS Management Console and navigate to the RDS dashboard at https://console.aws.amazon.com/rds/.
- In the left navigation panel, click on
Databases.- Select the RDS instance that you want to examine.
- Click on the
Maintenance and backupspanel.- Under the
Maintenancesection, search for the Auto Minor Version Upgrade status.... see more
Remediationโ
Remediationโ
Enable Auto Minor Version Upgradeโ
Using AWS CloudFormationโ
- CloudFormation template (YAML):
AWSTemplateFormatVersion: '2010-09-09'
Description: Enables automatic minor version upgrades for an existing RDS instance.
Parameters:
DBInstanceIdentifier:
Type: String
Description: ID of the existing RDS instance
Resources:
AutoMinorUpgradeRDS:
Type: AWS::RDS::DBInstance
Properties:
DBInstanceIdentifier: !Ref DBInstanceIdentifier
AutoMinorVersionUpgrade: trueUsing Terraformโ
- Terraform configuration file (.tf):
terraform {
required_providers {
aws = {
source = "hashicorp/aws"
version = "~> 3.27"
}
}
required_version = ">= 0.14.9"
}
provider "aws" {
profile = "default"
region = "us-east-1"
}
resource "aws_db_instance" "rds-database-instance" {
allocated_storage = 20
engine = "mysql"
engine_version = "5.7"
instance_class = "db.t2.small"
name = "mysqldb"
username = "ccmysqluser01"
password = "ccmysqluserpwd"
... [see more](remediation.md)