AWS Builder Center
How to Identify Parameter Group Changes Before an Amazon RDS Major Version Upgrade

How to Identify Parameter Group Changes Before an Amazon RDS Major Version Upgrade

Planning an Amazon RDS major version upgrade? Learn how to compare custom and default DB parameter groups using the AWS Management Console. This simple approach helps identify configuration changes before upgrading MySQL or PostgreSQL databases, reducing upgrade risks and ensuring important settings aren't missed.

Building Reliable Systems in the Cloud | DevOps • Automation • I

Introduction

When planning a major version upgrade for Amazon RDS, most teams focus on engine compatibility, backups, and maintenance windows.
However, one important step is often overlooked reviewing the DB Parameter Group.
Over time, database administrators modify parameters to improve performance, enable logging, or support application requirements. During a major version upgrade, these custom settings need to be reviewed because some parameters may have changed, been deprecated, or no longer exist in the target engine version.
Fortunately, the AWS Management Console provides a simple way to compare parameter groups without manually checking hundreds of settings.
In this article, I'll demonstrate how to use the Compare Parameter Groups feature for both Amazon RDS MySQL and Amazon RDS PostgreSQL.
A diagram showing an Amazon RDS major version upgrade workflow where the current and target DB parameter groups are compared to identify compatible, changed, deprecated, and removed parameters before upgrading.


Why Compare Parameter Groups?

Imagine you're upgrading:
PostgreSQL 16 ↓ PostgreSQL 17
or
MySQL 8.0 ↓ MySQL 8.4
Instead of manually reviewing every parameter, you can compare your custom parameter group with the default parameter group.
This quickly highlights only the parameters that are different.
The comparison immediately highlights this difference, making it easy to decide whether the custom configuration should be retained after the upgrade.

Step 1: Open Parameter Groups

From the AWS Management Console:
Amazon RDS → Parameter Groups
Locate the custom parameter group attached to your database.
An AWS Management Console screenshot showing the Custom parameter groups page for Amazon RDS. The parameter group names, descriptions, and AWS account IDs are hidden.


Step 2: Select Your Custom Parameter Group

Select your custom parameter group.
Choose: Actions → Compare
The AWS console will prompt you to choose another parameter group for comparison.
For a major version upgrade, compare your custom parameter group with the default parameter group.
The Amazon RDS console showing the Parameter groups page with multiple custom parameter groups selected and the Compare option available in the Actions menu.


Step 3: Review the Differences

AWS displays only the parameters whose values differ.
This makes it much easier to identify configuration changes without reviewing every parameter.
An AWS Management Console screenshot showing the Parameters comparison page, where a custom DB parameter group is compared with the default MySQL 8.0 parameter group. The custom parameter group name is hidden.


Why This Matters During Major Version Upgrades

Some parameters:
  • No longer exist
  • Have different default values
  • Accept different ranges
  • Require a reboot
  • Behave differently in newer engine versions
Comparing parameter groups helps identify these changes before performing the upgrade.

Supported Engines

This feature is useful for any Amazon RDS engine that uses parameter groups, including:
  • Amazon RDS for PostgreSQL
  • Amazon RDS for MySQL
  • Amazon Aurora PostgreSQL
  • Amazon Aurora MySQL
  • Amazon MariaDB

Best Practices

  • Compare parameter groups before every major version upgrade.
  • Review each customised parameter.
  • Don't assume older parameter values are still appropriate.
  • Test the upgraded parameter group in a non-production environment.
  • Keep documentation of important custom parameters.

Conclusion

Major version upgrades involve more than upgrading the database engine.
Reviewing your DB parameter group is an important validation step that helps ensure critical configuration changes are not overlooked.
The Compare Parameter Groups feature in the AWS Management Console provides a quick and reliable way to identify differences between custom and default parameter groups, making upgrade planning simpler and reducing the risk of configuration related issues.
Any opinions in this article are those of the individual author and may not reflect the opinions of AWS.
Enjoyed reading this content? Let the author know!

Your likes, comments, shares, and saves help creators reach more builders.

Loading recommendations

Loading article