Skip to main content

Create and manage parameter groups

A parameter group lets you view MySQL parameters by engine version and manage settings applied to connected instance groups.

Notes when changing parameters

The parameter list and basic concepts provided by KakaoCloud MySQL follow the MySQL official documentation. Changing parameters may affect MySQL service operation, so review the purpose and values of each parameter before making changes.

Event notifications

You can receive notifications for events such as parameter group creation and modification in Alert Center > Event notifications. For available events, see Cloud Trail. For instructions on configuring event notifications, see Alert Center > Create and manage alert policies.

View parameter group list​

You can view the default and custom parameter groups provided by KakaoCloud MySQL.

  1. Go to the KakaoCloud Console > Data Store > MySQL.

  2. Click Parameter Groups, and select the Custom Groups or Default Groups tab based on the parameter group type.

  3. View the parameter groups on the selected tab.

    ItemDescription
    NameName of the parameter group
    Engine VersionMySQL engine version compatible with the parameter group
    Connected Instance GroupsNumber of instance groups connected to this parameter group
    - A warning icon is shown if there's an issue with parameter application status
    DescriptionDescription of the parameter group
    [⋮] buttonAvailable only for custom groups
    - Edit: Modify parameters
    - Copy: Create a new parameter group with the same parameters
    - Reset to default: Reset the group parameters to their values at the time of creation
    - Roll back: Revert the group parameters to their previous values. Rollback is unavailable if the parameters have not been modified or have already been rolled back
    - Delete: Delete the group

View parameter group details​

You can view detailed information about a MySQL parameter group by tab.

  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups, and select the Custom Groups or Default Groups tab based on the parameter group type.
  3. Select the parameter group whose details you want to view.

The parameter group details page contains the following tabs:

  • Parameters: View the parameter name, value, type, data type, and editability. Depending on the type, such as Static, modifying a parameter might require an instance restart. For precautions when modifying parameters, see Modify parameter group.
  • Connected instance groups: View the connected instance groups and their parameter application status. If the status is Error-Sync or Suspended, click [Retry] to request that the parameters be applied to the connected instance group again. For details about each status, see Parameter application status.
  • Recent events: View major parameter group events from the past seven days, including the event time, event name, result, and related instance group.

The Recent events tab displays the following events:

Group TypeEvent NameDescription
Custom parameter groupCreate Parameter GroupOccurs when a custom parameter group is created
Update Parameter GroupOccurs when custom parameter group information, such as its description, is updated
Update ParameterOccurs when a parameter value is updated
Reset ParametersOccurs when a request is made to reset parameter values to their defaults
Rollback ParametersOccurs when a parameter rollback is requested
Apply Instance GroupOccurs when the parameter group has been applied to an instance group
Retry ParametersOccurs when a retry is requested after the parameter group fails to apply to an instance group
Default parameter groupApply Instance GroupOccurs when the parameter group has been applied to an instance group

Create parameter group​

  1. Go to the KakaoCloud Console > Data Store > MySQL.

  2. Click Parameter Groups and select the Custom Groups tab.

  3. In the Custom Groups tab, click the icon > Create Parameter Group.

  4. Enter the required information on the Create parameter group page. Parameter values can be modified after the group is created.

    ItemCategoryDescription
    Basic SettingsParameter Group NameName of the parameter group
    - Duplicate names cannot be used within the same project
    Description (Optional)Additional description up to 100 characters
    Parameter Group SettingsEngine VersionMySQL engine version for the parameter group
    Default Parameter GroupSelect the default parameter group provided for the engine version
    ParametersInitial parameter values for the group

Modify parameter group​

After creating a custom parameter group, you can modify its description and parameter values. Only parameters marked as Editable can be modified. After you modify a value, its editability changes to Editable (Modified).

Modification notes
  • Some Dynamic parameters apply globally and require a session refresh.
  • For Static parameters, modifying them triggers a restart of the connected instance groups.
  • If the parameter application status of a connected instance group is Pending or Applying, or if the instance group status is Storage-Full(Error), parameters cannot be modified.
  • Checkboxes remain selected even when navigating through pages within the modifiable parameter list.
Modification cautions
  • Some parameters may affect MySQL service operation when modified. Refer to Parameters to be careful when modifying.
  • If issues occur after modification, it is recommended to create a parameter group copy for backup, and use retry/rollback/reset options when needed.

  1. Go to the KakaoCloud Console > Data Store > MySQL.

  2. Click Parameter Groups and navigate to the Custom Groups tab.

  3. Select the parameter group you want to modify and click the [⋮] button > Edit.

  4. Modify the required values on the Edit Parameter Group page.

    ItemCategoryDescription
    Basic InformationParameter Group NameName of the parameter group
    Description (Optional)Additional description up to 100 characters
    Editable ParametersList of parameters that can be modified
    - Modified parameters change to Editable (Modified)

  5. Enter a Value manually or use Load Existing Parameters to import parameter values from an existing custom parameter group. You can also use Reset to Default to enter the default values from the time of creation. After making the required changes, click [Edit].

  6. Review the changes in the parameter modification confirmation modal. If multiple instance groups are connected to the parameter group, select one of the following application methods:
    - Apply All: Apply the modified parameters to all instance groups at once
    - Apply Sequentially: Apply the modified parameters to each instance group sequentially

Load existing parameters​

You can load parameter values from an existing custom parameter group, regardless of version. Since loaded values replace the existing ones, we recommend saving any necessary information before loading.

  1. Go to the Edit parameter group page.
  2. In the Load Existing Parameters popup, select the engine version and the target custom parameter group.
  3. Review the parameters to be loaded and click Apply.

Copy parameter group​

Custom parameter groups provide a copy feature that can be used for backup purposes. You can duplicate a selected parameter group to create a new one.

  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups and select the Custom Groups tab.
  3. Find the parameter group you want to copy, click the [⋮] button, and select Copy.
  4. Review the information in the popup and click [Copy].
  5. Check the copied parameter group in the Custom Groups tab.

Reset parameter group to default values​

Custom parameter groups support a reset-to-default feature, which allows you to revert modified parameters back to their default values. The default value is the engine version’s base configuration at the time the group was created. Resetting will attempt to apply parameter changes to all connected instance groups.

Reset notes
  • If the parameter application status of a connected instance group is Pending or Applying, or if the instance group status is Storage-Full(Error), you cannot reset parameters to default.
  • Resetting a Static parameter will restart the connected instance group.
  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups and select the Custom Groups tab.
  3. Locate the group to reset, click the [⋮] button, and select Reset to Default Values.
  4. Review the information in the popup and click [Reset]. If multiple instance groups are connected to the parameter group, select one of the following application methods:
    - Apply All: Apply the modified parameters to all instance groups at once
    - Apply Sequentially: Apply the modified parameters to each instance group sequentially
  5. For connected instance groups, verify the parameter application status after reset.

Roll back parameter group​

Custom parameter groups provide a rollback feature that lets you revert parameter values to their previous values after a modification. You can use this feature only if the parameter group has a modification history immediately before the rollback.

Rollback notes
  • You cannot roll back if the parameter application status of a connected instance group is Pending or Applying, or if the instance group status is Storage-Full(Error).
  • Rolling back a Static parameter will restart the connected instance group.
  • Once rollback is performed, previous values are restored and cannot be rolled back again. If new modifications are made, rollback becomes available again.
  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups and select the Custom Groups tab.
  3. Find the group to roll back, click the [⋮] button, and select Roll Back.
  4. Review the information in the popup and click [Roll back].
  5. For connected instance groups, verify whether the rollback was applied by checking the parameter application status.

Delete parameter group​

If a custom parameter group is no longer needed, it can be deleted.

Deletion notes
  • Default parameter groups cannot be deleted.
  • If the parameter group is connected to any instance group, it cannot be deleted.
  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups and select the Custom Groups tab.
  3. Locate the group to delete, click the [⋮] button, and select Delete.
  4. In the delete popup, provide the required information and click Confirm.
  5. Verify the deletion in the Custom Groups tab.

Retry applying parameter group​

You can retry applying a parameter group only when the parameter status of a connected instance is Error-Sync or Suspended (not In-Sync).
For more details on parameter application statuses, refer to Parameter Application Status.

  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. Click Parameter Groups and select the Custom Groups tab.
  3. Select the parameter group for which you want to retry parameter application.
  4. Go to the Connected Instance Groups tab.
  5. Click the Retry button next to the instance you want to retry applying the parameters to.

Check parameter group engine version​

If the engine version of an instance group does not match the parameter group, a Check Engine Version badge is displayed. Custom parameter groups with this badge cannot be modified for service stability.

You can check instance groups with mismatched engine versions in Parameter Groups > Instances. If you use Change parameter group on the instance group and change it to a parameter group that matches the engine version, the badge disappears.

To keep using previously configured parameter values, create a new parameter group that matches the engine version, then use Load Existing Parameters in Modify parameter group.

  • Where to check: Parameter Groups > Instances
  • Cause: The engine version of the connected instance group and parameter group do not match due to version upgrade or similar work
  • Action: Change to a parameter group that matches the engine version