Updated on 2023-10-09 GMT+08:00

Creating a Parameter Template

A database parameter template acts as a container for parameter configurations 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.

If 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:

  • Changing parameter values in a parameter template only changes parameters in the DDM instance where the template has been applied to.
  • 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. Remember 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.
  • Each user can create up to 100 parameter templates.
  • The parameter template quota is shared by all DDM instances in a project.

Procedure

  1. Log in to the DDM console.
  2. Choose Parameter Templates and click Create Parameter Template.
  3. In the displayed dialog box, enter a template name and description and click OK.

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