Replicating a Parameter Template

Scenarios

You can replicate a parameter template you have created. When you have already created a parameter template and want to include most of the custom parameters and values from that template in a new parameter template, you can replicate that parameter template. You can also export the parameter template to generate a new parameter template for future use.

After a parameter template is replicated, it takes about 5 minutes before the new template is displayed.

Default parameter templates cannot be replicated, but you can create parameter templates based on the default ones.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Parameter Templates page, click Custom Templates. Locate the target parameter template and click Replicate in the Operation column.

   Alternatively, click the target DB instance on the Instances page. On the Parameters page, click Export to generate a new parameter template for future use.

   

   To ensure that your parameter templates are applicable to all types of DB instances and databases can be started normally, the values of innodb_flush_log_at_trx_commit and sync_binlog exported from primary DB instances or read replicas are 1 by default.

5. In the displayed dialog box, configure required information and click Yes.
   Figure 1 Replicating a parameter template
   
   • The template name must consist of 1 to 64 characters. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), underscores (_), and periods (.).
   • The description consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=

   After the parameter template is replicated, a new template is generated in the list on the Parameter Templates page.