This topic describes how to manage the parameters of an ApsaraDB for RDS instance by using a parameter template.

Prerequisites

The RDS instance runs one of the following MySQL versions:
  • MySQL 8.0
  • MySQL 5.7
  • MySQL 5.6

Background information

For more information about how to reconfigure a single parameter, see Reconfigure parameters for an RDS MySQL instance.

Create a parameter template

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the target RDS instance resides.
    Select a region
  3. In the left-side navigation pane, click Parameter Templates. In the upper-right corner, click Create Parameter Template.
    Create a parameter template
  4. Configure the following parameters.
    Parameter Description
    Template Name Enter the name of the parameter template. The name must be 8 to 64 characters in length. It can contain letters, digits, periods (.), and underscores (_). It must start with a letter.
    Database Engine Only MySQL is supported.
    Engine Version Only MySQL 5.6, 5.7, and 8.0 are supported.
    Description Enter a description that helps identify the parameter template. The description can be up to 200 characters in length.
    Add Parameter Click Add Parameter and select a parameter from the Parameter drop-down list. Then, you can set the parameter and view its value range and default value.
    Note
    • If you want to add another parameter, you must click Add Parameter again.
    • If you want to remove a parameter, you must click Delete to the right of the parameter.
    Add a parameter
    Import If you have exported a parameter template to your computer, you can edit that template based on your business needs and then click Import to copy its parameters. For more information about how to export a parameter template file, see Reconfigure parameters for an RDS MySQL instance.
  5. Click Confirm.

Manage parameter templates

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the target RDS instance resides.
    Select a region
  3. In the left-side navigation pane, select Parameter Templates.
    View the parameter template list
  4. Manage parameter templates in this region.
    To view a parameter template, follow these steps:

    Find the target parameter template, and click View in the Actions column. On the page that appears, view the basic information and parameters of the template.

    View a parameter template
    To apply a parameter template to an RDS instance, follow these steps:
    Note Before you apply a parameter template to multiple RDS instances, you must verify that the parameter template is suitable for the RDS instances.
    1. Find the parameter template, and click Apply to Instance in the Actions column.
    2. Select RDS instances from the All Instances section, click to move them to the Selected Instances section, and check the parameter comparison.
    3. Click OK.
    To clone a parameter template from one region to another, follow these steps:
    1. Find the target parameter template, and click Clone in the Actions column.
    2. Configure the following parameters.
      Parameter Description
      Region Select the destination region to which you want to clone the parameter template.
      Template Name Enter the name of the parameter template. The name must be 8 to 64 characters in length. It can contain letters, digits, periods (.), and underscores (_). It must start with a letter.
      Description Enter a description that helps identify the parameter template. The description can be up to 200 characters in length.
    3. Click OK.
    To modify a parameter template, follow these steps:
    1. Find the target parameter template, and click Edit in the Actions column. For more information, see Step 4 in the "Create a parameter template" section.
    2. Click Edit.
    To delete a parameter template, follow these steps:

    Find the target parameter template, and click Delete. In the message that appears, click OK.

    Note When you delete a parameter template, it does not affect the RDS instances to which the template is applied.

Related operations

Operation Description
CreateParameterGroup Creates an ApsaraDB for RDS parameter template.
ModifyParameterGroup Modifies an ApsaraDB for RDS parameter template.
CloneParameterGroup Clones an ApsaraDB for RDS parameter template from one region to another.
DescribeParameterGroups Queries the ApsaraDB for RDS parameter templates available to a region.
DescribeParameterGroup Queries an ApsaraDB for RDS parameter template.
DeleteParameterGroup Deletes an ApsaraDB for RDS parameter template.