In addition to the various system parameter templates provided by TDSQL-C for MySQL, you can also create custom parameter templates to configure parameters in batches as needed.
You can apply a parameter template to configure and manage the parameters of a database engine. A template is like a container of the values of database engine parameters, which can be applied to one or more database instances.
You can log in to the console and click Parameter Template on the left sidebar to view parameters. The following parameter template features are supported:
Use a default parameter template. The default parameter values improve the TDSQL-C for MySQL performance while guaranteeing the stability.
Create custom templates by modifying a default parameter template.
Generate templates by importing parameters from configuration file my.conf.
Save parameter configurations as templates.
Set the values of certain parameters in a parameter template based on formula.
Note
If the parameters in the template are updated, the instance parameters are not updated unless they are manually re-applied to the instances.
You can apply the parameter changes to single or multiple instances by importing a template.
Creating a Parameter Template
To use your own database parameter template, you can create a parameter template, modify the parameter values, and apply the template to instances.
1. Log in to the TDSQL-C for MySQL console, select Parameter Template on the left sidebar, and click Create Template.
2. In the pop-up window, configure the following parameters and click OK.
Parameter
Description
Template Name
Enter a unique template name.
Template Description
Enter a brief description of the parameter template.
Template Type
Select the template type: General for a monthly subscribed or pay-as-you-go cluster or Serverless for a Serverless cluster.
Database Version
Select the required database version.
3. After the creation is completed, you can modify, import, and export parameters on the template details page.
Copying a Parameter Template
To include most of the custom parameters and values of an existing parameter template in a new template, you can copy the existing template.
Option 1. Copying an existing parameter template
1. Log in to the TDSQL-C for MySQL console, select Parameter Template on the left sidebar, find the target parameter template, and click View/Modify in the Operation column to enter the template details page.
2. Click Save as Template at the top of the template details page.
3. In the pop-up window, configure the following parameters:
Template Name: Enter a unique template name.
Template Description: Enter a brief description of the parameter template.
4. After confirming that everything is correct, click OK.
Option 2. Saving parameters of an instance as a parameter template
1. Log in to the TDSQL-C for MySQL console, find the target cluster in the cluster list, and click the cluster ID to enter the cluster management page.
2. On the cluster management page, select the Parameter Settings tab and click Save as Template.
3. In the pop-up window, configure the following parameters:
Template Name: Enter a unique template name.
Template Description: Enter a brief description of the parameter template.
4. After confirming that everything is correct, click OK.
Modifying Parameter Values in a Parameter Template
1. Log in to the TDSQL-C for MySQL console, select Parameter Template on the left sidebar, find the target parameter template, and click View/Modify in the Operation column to enter the template details page.
2. Click Modify Parameters or in the Current Value column to modify parameter values.
Note
If you click Import Parameters, you need to upload a local parameter configuration file. To avoid importing failures, the configuration file should be in the same format as the configuration file of the MySQL database server, or you can use the file template of the exported parameters.
Importing a Parameter Template
1. Log in to the TDSQL-C for MySQL console, select Parameter Template on the left sidebar, find the target parameter template, and click View/Modify in the Operation column to enter the template details page.
2. On the template details page, click Import Parameters.
Note
If you click Import Parameters, you need to upload a local parameter configuration file. To avoid importing failures, the configuration file should be in the same format as the configuration file of the MySQL database server, or you can use the file template of the exported parameters.
3. In the pop-up window, select a file and click Import and Overwrite Original Parameters.
Exporting a Parameter Template
Note
Currently, when you export a parameter template, formula-based parameter values will be automatically converted into integer values for export.
2. In the parameter template list, find the target template and click Export in the Operation column.
Option 2
1. Log in to the TDSQL-C for MySQL console, select Parameter Template on the left sidebar, and click View/Modify in the Operation column of a template to enter the template details page.
2. Click Export Parameters at the top of the template details page.
Deleting a Parameter Template
If a parameter template is created redundantly or no longer needed, it can be easily deleted.
Yes
No
Was this page helpful?