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

The instance version is one of the following:
  • MySQL 8.0
  • MySQL 5.7
  • MySQL 5.6

Background information

If you only want to reconfigure only one parameter of an RDS instance, see Reconfigure parameters for an RDS for MySQL instance.

Create a parameter template

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.

    选择地域
  3. In the left-side navigation pane, click Parameter Templates, and in the upper-right corner click Create Parameter Template.

    新建参数模板
  4. 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.
  5. Click Confirm.

Manage parameter templates

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.

    选择地域
  3. the left-side navigation pane, click Parameter Templates.

    查看参数模板列表
  4. 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.
    1. Find the parameter template and in the Actions column click Apply to Instance.
    2. Select RDS instances from the All Instances section, and click 右箭头 to move them to the Selected Instances section. Then, check the parameter comparison information.

      选择需要应用参数模板的实例
    3. Click OK.
    To replicate a parameter template from one region to another, follow these steps:
    1. Find the parameter template and in the Actions column click Clone.
    2. 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.

      设置模板参数
    3. Click OK.
    To modify a parameter template, follow these steps:
    1. Find the parameter template and in the Actions column click Edit. On the displayed page, modify the parameter template as needed.
    2. 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.