This topic describes how to create, manage, and use parameter templates. You can use a parameter template to manage RDS for MySQL instances in batches.
Prerequisites
- MySQL 8.0
- MySQL 5.7
- MySQL 5.6
Background information
Create a parameter template
- In the upper-left corner, select the region where the target RDS instance is located.
- In the left-side navigation pane, click Parameter Templates, and in the upper-right corner click Create Parameter Template.
- Set the following parameters.
Parameter Description Template Name The name of the parameter template. The template name must start with a letter and can contain 8 to 64 characters including letters, digits, decimal points (.), and underscores (_). Database Engine Only one option is available: MySQL. Version Two options are available: MySQL 5.6 and MySQL 5.7. Description The description of the parameter template for easy template management. The description can contain up to 200 characters. Add Parameter If you click Add Parameter, a modifiable parameter entry is displayed for you to specify the parameter name and value. Additionally, you can view the other information such as the value range and default value. Note- To configure one more parameter, you can click Add Parameter again.
- To delete a parameter, you can click Delete for the parameter entry.
Import After modifying an exported parameter template, you can click Import to paste this parameter template. For more information about parameter template export, see Reconfigure parameters for an RDS for MySQL instance.
Manage parameter templates
- In the upper-left corner, select the region where the target RDS instance is located.
- the left-side navigation pane, click Parameter Templates.
- Perform operations on parameter templates as needed.
To view a parameter template, follow these steps:
Find the parameter template and in the Actions column click View. Then, you can view the basic information and parameter details of the template.
To apply a parameter template to one or more RDS instances, follow these steps:Note Before you apply a parameter template to more than one RDS instance, you must make sure that these parameters are suitable to these instances.- Select RDS instances from the All Instances section, and click
to move them to the section. Then, check the parameter comparison information.
To replicate a parameter template from one region to another, follow these steps:- Set the following parameters
Parameter Description Region The destination region to which the parameter template is to be replicated. Parameter Template The name of the parameter template. The template name must start with a letter and can contain 8 to 64 characters including letters, digits, decimal points (.), and underscores (_). Description The description of the parameter template for easy template management. The description can contain up to 200 characters. 
To modify a parameter template, follow these steps:- Find the parameter template and in the Actions column click Edit. On the displayed page, modify the parameter template as needed.
- Click Edit.
To delete a parameter template, follow these steps:Find the parameter template and in the Actions column click Delete. In the displayed dialog box, click OK.
Note Deleting a parameter template does not affect the RDS instances to which the template is applied. - Select RDS instances from the All Instances section, and click