Resetting a Parameter Template
Scenarios
You can reset all parameters in a custom parameter template to their default settings.
Procedure
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service.
- On the Parameter Templates page, click Custom Templates. Locate the target parameter template and choose More > Reset in the Operation column.
- Click Yes.
- Apply the parameter template to your DB instance. For details, see Applying a Parameter Template.
- 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.
Parent topic: Parameter Templates
- Scenarios
- Procedure