Updated on 2022-12-08 GMT+08:00

Creating a Parameter Template

A database parameter template acts as a container for engine configuration values that can be applied to one or more DDM instances. You can manage configurations of a DDM instance by managing parameters in the parameter template applied to the instance.

If you do not specify a parameter template when creating a DDM instance, the system uses the default parameter template for your instance. The default parameter template contains multiple default values, which are determined based on the computing level and the storage space allocated to the instance. You cannot modify parameter settings of a default parameter template. You must create your own parameter template to change parameter settings.

If you want to use your custom parameter template, you simply create a parameter template and select it when you create a DDM instance or apply it to an existing DDM instance following the instructions provided in Applying a Parameter Template.

When you have already created a parameter template and want to provide most of its custom parameters and values in a new parameter template, you can replicate the template you created following the instructions provided in Replicating a Parameter Template.

The following are the key points you should know when using parameters from a parameter template:

  • When you change a parameter value in a parameter template that has been applied to a DB instance, the change applies only to the current DB instance and does not affect other DB instances.
  • When you change a parameter value in a parameter template and save the change, the change will take effect only after you apply the parameter template to a DDM instance and manually restart the instance.
  • Improper parameter settings may have unintended adverse effects, including degraded performance and system instability. Exercise caution when modifying parameters and you need to back up data before modifying parameters in a parameter template. Before applying parameter template changes to a production DDM instance, you should try out these changes on a test DDM instance.

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 Database > Distributed Database Middleware.
  4. Choose Parameter Templates and click Create Parameter Template.
  5. In the displayed dialog box, enter a template name and description and click OK.

    • The template name is case-sensitive and consists of 1 to 64 characters. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), underscores (_), and periods (.).
    • The template description consists of a maximum of 256 characters and cannot include carriage return characters and special characters >!<"&'=

      Each user can create up to 100 parameter templates.