Parameters¶
Database parameters
specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.
The user manages the DB configuration by associating DB instances with Parameter groups
.
ICDC Database includes parameter groups with default settings. You can also define your own parameter groups with individual settings.
A DB parameters group acts as a container for configuration values that apply to one or more DB instances.
The user cannot change the default parameter group settings. Instead, the following is possible:
- Creating a new group of parameters;
- Changing the settings of the desired parameters (not all DB parameters in the parameter group can be changed);
- Changing the DB instance to use a group of custom parameters.
Note
Incorrectly configuring settings in an option group may lead to unintended negative consequences, such as reduced performance and system instability. Be careful when changing database settings. Try changing the settings group settings on the test DB instance before applying those settings group changes to the production DB instance.
Parameter group creation¶
To create a parameter group, follow these steps:
- Navigate to the
Parameters
tab. - Click on
New parameter group
in the modal window. - Fill in the following values:
Parameter group name
;Database type
;Parent group
from which the new parameter group inherits its settings;Description of the parameter group
.
- Click
Create
.
Note
When selecting the database type Redis or Memcached, only standard default parameters are used; internal database parameters are not displayed.
The created group of parameters will be displayed in the Parameters
tab.
After selecting the created parameter group, the user has access to information about the parameter group (entered during creation) and the Parameter List
applied to this group. These settings are specific to the instance to which this parameter group is assigned.
A parameter with the attribute value Modifiable - True
is available for editing. If the parameter value is not filled in, it is controlled by the DB itself and is not predefined by the user or the service.
The Apply Type parameter can have two values:
dynamic
- the parameter is applied immediately;static
- the parameter is applied during the next maintenance window.
Note
Deleting
a group of parameters is an irreversible action.
Roles and Permissions¶
Action | Member | Admin | Billing | Operator | Owner |
---|---|---|---|---|---|
Create Parameters Group | ✔ | ✔ | ✔ | ✔ | ✔ |
Delete Parameters Group | ✔ only own | ✔ | ✔ only own | ✔ | ✔ |
Enter Value Parameters Group | ✔ only own | ✔ | ✔ only own | ✔ | ✔ |