Use a parameter template to manage parameters

System template introduction

ApsaraDB RDS for MySQL on High-availability Edition and Basic Edition instances can use the following system parameter templates:

• Default parameter template

  It ensures the highest data security but costs more time. Data is semi-synchronously replicated. The parameters are specified with the following values to protect data:

  • InnoDB
    • innodb_flush_log_at_trx_commit = 1
    • sync_binlog = 1
  • X-Engine (only the default parameter template is provided)

    sync_binlog = 1

• Asynchronous parameter template

  It ensures high data security and fast speed. Data is asynchronously replicated. The parameters are specified with the following values to protect data:

  • innodb_flush_log_at_trx_commit = 1
  • sync_binlog = 1
• High-performance parameter template

  It ensures average data security but is less time-intensive to implement. Data is asynchronously replicated. The parameters are specified with the following values to protect data:

  • innodb_flush_log_at_trx_commit = 2
  • sync_binlog = 1000

The following table describes the parameters in the system parameter templates.

Apply a parameter template

1. Log on to the ApsaraDB for RDS console.
2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
   
3. In the left-side navigation pane, click Parameter Templates.
   
4. On the Custom Parameter Templates or System Parameter Templates tab, find the template that you want to apply.
5. Click Apply to Instance in the Actions column.
6. Select RDS instances from the All Instances section, click the icon to move them to the Selected Instances section, and then check the parameter comparison.
   Note Before you apply a parameter template to multiple RDS instances, you must verify that the parameters are suitable for the RDS instances.

   
7. Click OK.

Create a custom parameter template

1. Log on to the ApsaraDB for RDS console.
2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
   
3. In the left-side navigation pane, click Parameter Templates. In the upper-right corner of the page, click Create Parameter Template.
   
4. Configure the following parameters.

   Parameter	Description
   Template Name	The name of the parameter template. The name must be 8 to 64 characters in length and can contain letters, digits, periods (.), and underscores (_). It must start with a letter.
   Database Engine	The engine of the database. Set the value to MySQL.
   Engine Version	The version of the database engine. Valid values: MySQL 5.6, 5.7, and 8.0.
   Description	The 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 value as well as view the value range and default value. Note For more information about available parameters, see Editable Parameters on the Parameters page. 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.
   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, see Reconfigure the parameters of an ApsaraDB RDS for MySQL instance.

5. Click Confirm.

Clone a parameter template

You can clone a parameter template from the current region to another region.

1. Log on to the ApsaraDB for RDS console.
2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
   
3. In the left-side navigation pane, click Parameter Templates.
   
4. Find the target parameter template, and click Clone in the Actions column.
5. Configure the following parameters.

   Parameter	Description
   Region	The destination region to which you want to clone the parameter template.
   Template Name	The name of the parameter template. The name must be 8 to 64 characters in length and can contain letters, digits, periods (.), and underscores (_). It must start with a letter.
   Description	The description that helps identify the parameter template. The description can be up to 200 characters in length.

   
6. Click OK.

Manage parameter templates

1. Log on to the ApsaraDB for RDS console.
2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
   
3. In the left-side navigation pane, click Parameter Templates.
   
4. Manage parameter templates in this region.
   Note You can only perform the View and Apply to Instance operations on system templates.
   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.

   
   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 Actions column. 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