Updated on 2024-04-11 GMT+08:00

Resetting a Parameter Template

Scenarios

You can reset all parameters in a custom parameter template to their default settings.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Parameter Templates page, click Custom Templates. Locate the target parameter template and choose More > Reset in the Operation column.
  5. Click Yes.
  6. The modifications take effect only after you apply the parameter template to DB instances. For details, see Applying a Parameter Template.
  7. View the status of the DB instance to which the parameter template is applied.

    If the DB instance status is Parameter change. Pending reboot, a reboot is required for the modifications to take effect.

    • The DB instance reboot caused by instance class changes will not make parameter modifications take effect.
    • If you have modified parameters of a primary DB instance, you need to reboot the primary DB instance for the modifications to take effect. (For primary/standby DB instances, the parameter modifications are also applied to the standby DB instance.)
    • If you have modified parameters of a read replica, you need to reboot the read replica for the modifications to take effect.