Introduction
Last Updated：2021-04-29
Overview
Parameter template is a template that you can generate some modifiable parameters. If you need to set instance parameters in batches, you can use the parameter template function to quickly apply related parameters to target instance. Currently the parameter template supports user-defined parameter templates, the system parameter templates have not been determined yet.
Preconditions
- The product series supported, instance engines and version information are as follows:
- Stand-alone basic version: MySQL 5.7, 8.0
- Dual-computer HA version: MySQL 5.5, 5.6, 5.7, 8.0
- Read-only instance: MySQL 5.6、5.7
- Regions supported: all regions are supported
Use instructions
- Modifiable parameters: you can set the values of parameters in different ways according to the range of modifiable parameter values.
The detailed descriptions are as follows:
- Integer parameters (interger): modify the value of parameters through the input box.
- String type parameters (string): modify the value of parameters through the drop-down list.
- Set type parameter (set): modify the value of parameters through the check box.
- Restart effective parameters: if the result of "Need to restart" in the modifiable parameter list is "Yes", it means that the instance needs to be restarted after the modification of the current parameter, after that the modified parameter value can take effect.
- modifiable parameters with no need to restart: take effect immediately after the modification is completed. To cancel the modification, click "Restore" to reset the parameter values.
- modifiable parameters that need to restart: after modification, restart the instance, and the parameter value will take effect after the completion; to cancel the modification, click "Restore" to reset the parameter values.
- cluster parameters: this parameter can be set under both master instances and read-only instances. If you have modified this parameter in the master instance, the read-only instance will follow the synchronization setting, and there is no need to manually set the clustering parameters of the read-only instance.
4.The modifiable parameters of different versions are different, and the details are subject to the "modifiable parameters" of the console.
Custom parameter template
You can generate parameter templates with the modifiable parameters of RDS for MySQL instance.
Parameter templates support the following functions:
- Management: Support viewing the basic information, parameter details and application records of parameter templates, and you can edit, add, delete and operate the parameters in the template in batch.
- Apply to instance: support parameter templates to be applied to one instance at a time;
- Delete: you can delete the parameter template from the parameter template list.
Operation Guide
For detailed guide for use, please refer to: