Create Parameter Group in RDS

The engine configuration settings that are applied to one or more DB instances are contained in DB parameter groups.

Only Multi-AZ DB clusters are covered by DB cluster parameter groups. The parameters in the DB cluster parameter group are applied to all of the DB instances in a Multi-AZ DB cluster. Each DB instance in the DB cluster uses the default DB parameter group for the DB engine and DB engine version.

A default DB parameter group is used when a DB instance is created without a DB parameter group being specified. Similar to the previous example, a default DB cluster parameter group is used when a Multi-AZ DB cluster is created without a DB cluster parameter group being specified.

In accordance with the instance’s engine, compute class, and allotted storage, each default parameter group contains database engine defaults and Amazon RDS system settings. A default parameter group’s parameter settings cannot be changed. As an alternative, you create your own parameter group (refer to the below screenshot) and select your own parameter settings.

Click on the “Create Parameter Group”. You’ll be redirected to the below page.

create_parameter_group_0

Choose the desired parameter group from the “Parameter group family”.

In the drop-down you will see –

Arora MySQL older and new version parameter groups.
SQL Server based on the edition (enterprise, standard, etc).
Arora PostgreSQL older and new version parameter groups.
MariaDB older and newer version parameter groups.
Oracle DB older and newer version parameter groups.
Arora parameter groups.
MySQL parameter groups.
Custom SQL Server based on the edition (enterprise, standard, etc).

create_parameter_group2

In this case, I chose MySQL 8.0, the most recent version, for my parameter group.

create_parameter_group

Now, provide a name at “Group name”, which you will use it or map it to the DB instances.

Provide a description as well.

and done..!!

Your parameter group has been created. While creating your database instance, you can supply the parameter group. Alternatively, you can alter the current DB instance and switch the parameter group to the newly formed one.