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 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 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.