Luca shows you how to
compare parameters in different
RDS parameter groups

default-custom-groups-luca

You might need to review customized parameters for a custom parameter group to make a change or because you have encountered an incompatible-parameters issue.

It might be useful to compare the differences between the customized parameter group settings and determine which values are set by default. For example, you might want to determine which parameters triggered the incompatible-parameters issue by reviewing the default value and comparing the custom parameter group to the default parameter group for the RDS engine version.

Using the RDS Console

You can use the RDS console to compare two parameter groups. The result is a Parameters Comparison table that lists of all parameters and values.

  1. Ensure you have selected the region that contains the RDS instance.
  2. Choose Parameter Groups.
  3. Choose two parameter groups that you want to compare, and then choose Compare Parameters.

Examine the Parameters Comparison table to see which parameters are customized and the corresponding values for both default and custom parameter groups.

Using the AWS Command Line Interface

You can use the AWS CLI to compare between parameter groups by using the describe-db-parameters and describe-db-cluster-parameters commands.

The following command displays the settings for a parameter group, including the source for each:

aws rds describe-db-parameters --db-parameter-group-name INSERT-YOUR-PG-NAME-HERE --region INSERT-REGION-HERE

To list the default value for the engine family, you can use the same command or use the describe-engine-default-parameters for database-level parameters and the describe-engine-default-cluster-parameters for cluster level parameters.

The following sample code displays the default parameters for the MySQL engine version 5.6 parameter group family:

aws rds describe-engine-default-parameters --db-parameter-group-family mysql5.6

There is no AWS CLI command to compare two parameter groups simultaneously; this feature is only available by using the RDS console. You can use the AWS CLI command --output text to list in plain text format instead of the default JSON format. You can then compare the plain text files that list the parameter groups using a Linux tool such as the diff command, or a source code editor like Notepad++.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2016-11-11