• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. Parameter Groups
  6. Creating a Parameter Group

Creating a Parameter Group

You can use database parameter groups to manage the configuration of a DB engine. A database parameter group acts as a container for engine configuration values that can be applied to one or more DB instances.

If you create a DB instance without specifying a custom DB parameter group, a default parameter group is used. This default group contains DB engine defaults and RDS system defaults based on the engine, compute class, and allocated storage of the instance. You cannot modify the parameter settings of a default parameter group. You must create your own parameter group to change parameter settings from their default value.

Note that not all DB engine parameters can be changed in a custom parameter group.

If you want to use your custom parameter group, you simply create a new parameter group and select it when you create a DB instance or apply it with an existing DB instance following the instructions provided in section Applying a Parameter Group to DB Instances.

When you have already created a parameter group and want to include most of the custom parameters and values from that group in a new parameter group, you can replicate that parameter group following the instructions provided in section Replicating a Parameter Group.

The following are the key points you should know when using parameters in a parameter group:

  • When you change parameter values in a parameter group and save the changes, the changes apply only to current DB instance and do not affect the other DB instances.
  • When you change a dynamic parameter and save the changes, the changes apply immediately regardless of the Effective upon Reboot setting. When you change a static parameter and save the change, the change will take effect only after you apply the parameter group to a DB instance and manually reboot the instance.
  • When you change parameter values in parameter groups in batches and save the changes, the changes will take effect only after you apply the parameter groups to DB instances. For details, see section Applying a Parameter Group to DB Instances. When you change a static parameter and save the change, the change will take effect only after you apply the parameter group to a DB instance and manually reboot the instance.
  • Improperly setting parameters in a parameter group may have unintended adverse effects, including degraded performance and system instability. Exercise caution when modifying database parameters and back up data before modifying a parameter group. Before applying parameter group changes to a production DB instance, you should try out these changes on a test DB instance.

Scenarios

DB parameter groups act as a container for engine configuration values that are applied to one or more DB instances. You can create parameter groups on the RDS console.

NOTE:

RDS does not share parameter group quotas with DDS.

By default, each user can create a maximum of 1,000 parameter groups for RDS DB instances. All RDS DB engines share the parameter group quota.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Parameter Group Management page, click Create Parameter Group.
  5. Specify DB Engine Version, Parameter Group Name, and Description. Then, click OK.

    • The DB engine version indicates the engine version of the DB instance to which this parameter group will apply. For example, if you want to apply this parameter group to a MySQL 5.6 DB instance, select MySQL 5.6.
    • The group name must consist of 1 to 64 characters. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), underscores (_), and periods (.).
    • The description must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: >!<"&'=