Updated on 2024-10-14 GMT+08:00

Creating a Parameter Template

You can use database parameter templates to manage the DB engine configuration. A database parameter template acts as a container for engine configuration values that can be applied to one or more DB instances. This section describes how to create a parameter template.

Scenarios

If you create a DB instance without specifying a custom DB parameter template, a default parameter template is used. This default template contains DB engine defaults and system defaults that are configured based on the engine, compute class, and allocated storage of the instance. Default parameter templates cannot be modified, but you can create your own parameter template to change parameter settings.

Precautions

  • Not all of the DB engine parameters in a custom parameter template can be changed.
  • If you want to use a custom parameter template, you simply create a parameter template and select it when you create a DB instance or apply it to an existing DB instance following the instructions provided in Applying a Parameter Template.
  • 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 following the instructions provided in Replicating a Parameter Template.
  • RDS does not share parameter template quotas with DDS. You can create a maximum of 100 parameter templates for RDS DB instances. All RDS DB engines share the parameter template quota.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. In the navigation pane on the left, choose Parameter Templates.
  4. On the Parameter Templates page, click Create Parameter Template.

    Figure 1 Creating a parameter template

  5. In the displayed dialog box, configure required information.

    • Select MariaDB 10.5 for DB Engine Version.
    • 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: >!<"&'=

  6. Click OK to create a parameter template.