ApsaraDB RDS:Use a parameter template to configure the parameters of ApsaraDB RDS for MySQL instances

Introduction to system templates

ApsaraDB RDS for MySQL provides the following system parameter templates for RDS instances that run RDS Basic Edition, RDS High-availability Edition, RDS cluster Edition:

• MGR parameter template

  This MySQL group replication (MGR) parameter template ensures the highest data security and strong data consistency. However, it delivers slow read and write performance. If you use this parameter template, data is replicated in MGR mode. The following parameter settings are fixed in this parameter template to ensure data security:

  InnoDB

  • innodb_flush_log_at_trx_commit = 1
  • sync_binlog = 1
• Default parameter template

  This parameter template provides high data security but delivers relatively slow read and write performance. If you use this parameter template, data is replicated in semi-synchronous mode. The following parameter settings are fixed in this parameter template to ensure data security:

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

    sync_binlog = 1

  Note

  • When you create an RDS instance, the default parameter template that matches the specified database engine version and RDS edition is selected by default. You can perform the following operations to view the parameter settings of the default parameter template: Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. On the page that appears, click the System Parameter Templates tab and search for the default parameter template to view all parameter settings in the default parameter template.
  • You cannot modify the default parameter template.
• Asynchronous parameter template

  This parameter template ensures high data security and fast speed. If you use this parameter template, data is replicated in asynchronous mode. The following parameter settings are fixed in this parameter template to ensure data security:

  • innodb_flush_log_at_trx_commit = 1
  • sync_binlog=1
  • rpl_semi_sync_master_enabled=off
  Note For more information about how to change the data replication mode to asynchronous, see Change of the data replication mode.
• High-performance parameter template

  This parameter template provides average data security but delivers the fastest read and write performance. If you use this parameter template, data is replicated in asynchronous mode. The following parameter settings are fixed in this parameter template to ensure data security:

  • 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 RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select the region in which the RDS instance resides.
2. On the Custom Parameter Templates or System Parameter Templates tab, find the parameter template that you want to apply and choose > Apply to Instance in the Actions column.
3. In the All Instances section of the panel that appears, select the RDS instances to which you want to apply the parameter template, click the icon to move the selected RDS instances to the Selected Instances section, and then view the changes to the parameter settings in the Parameter Comparison section.
   Important Before you apply a parameter template to multiple RDS instances, you must verify that the parameter settings are suitable for all the RDS instances. Proceed with caution.
4. Click OK.

Create a custom parameter template

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region in which your RDS instance resides.
2. In the left-side navigation pane, click Parameter Templates. On the Parameter Templates page, click Create Parameter Template.
3. Configure the following parameters.

   Parameter	Description
   Template Name	Enter a name for the parameter template. The name must be 8 to 64 characters in length and can contain letters, digits, periods (.), and underscores (_). The name must start with a letter.
   Database Engine	Select the database engine that is run by the RDS instance. Set the value to MySQL.
   Engine Version	Select the version of the database engine that is run by the RDS instance. Valid values: 5.6, 5.7, and 8.0.
   Description	Enter a description for 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 configure the parameter. You can also view the value range and default value of the parameter. Note To view the parameters that can be added or modified, perform the following operations: Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Click the ID of the RDS instance. In the left-side navigation pane, click Parameters. On the Editable Parameters tab, view the parameters that can be added or modified. If you want to add another parameter, you must click Add Parameter again. To delete a parameter, you must click Delete to the right of the parameter.
   Import	After you export a parameter template to your computer, you can edit the parameter template based on your business requirements. Then, you can click Import to copy the parameter settings from the parameter template to the RDS instance. For more information about how to export a parameter template, see Modify the parameters of an ApsaraDB RDS for MySQL instance.

4. Click OK.

Clone a parameter template

If you want to clone a custom parameter template from the current region to another region or you want to modify the parameter settings of a custom parameter template, you can use the parameter template cloning feature.

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region in which your RDS instance resides.
2. In the left-side navigation pane, click Parameter Templates.
3. Find the parameter template that you want to clone, click the icon, and then select Clone in the Actions column.
4. Configure the following parameters.

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

5. Click OK.

Manage parameter templates

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region in which your RDS instance resides.
2. In the left-side navigation pane, click Parameter Templates.
3. Manage the parameter templates in this region.
   Note You can perform the View and Apply to Instance operations on system templates.
   View a parameter template.

   Find the parameter template that you want to view and click View in the Actions column to view the basic information and parameter settings of the parameter template.

   Modify a parameter template.
   1. Important

      • If you modify a custom parameter template, you must re-apply the custom parameter template to your RDS instance for the modification to take effect.
      • After the custom parameter template is re-applied to your RDS instance, your RDS instance may be restarted. If you modify the parameters for which instance restart is required for the modifications to take effect, you must restart your RDS instance.
      Find the parameter template that you want to modify, click the icon, and then select Modify in the Actions column. Alternatively, click Edit Parameter Template in the panel that appears after you click View in the Actions column of the parameter template. For more information, see Step 3 in the "Create a custom parameter template" section of this topic.
   2. Click OK.
   Delete a parameter template.

   Find the parameter template that you want to delete, click the icon, and then select Delete in the Actions column. In the message that appears, click OK.

   Note When you delete a parameter template, the RDS instances to which the parameter template is applied are not affected.

Related operations

FAQ

How do I reset the parameter values in a custom parameter template to their default values?