Configuration Options
You can manage instance groups in KakaoCloud MySQL using built-in stored procedures.
caution
This procedure only allows control of the read_only parameter. All other parameters cannot be modified.
Configuration change procedure
This stored procedure allows you to change parameters in a running MySQL instance within a DB engine.
Procedure name
mysql.mnms_set_configuration
Procedure parameters
| Name | Data Type | Description |
|---|---|---|
| p_name | varchar(200) | The name of the parameter to change. |
| p_value | varchar(200) | The new value to set for the parameter. |
How to use
CALL mysql.mnms_set_configuration('read_only', 1);
Example
-
Example of applying to both global and session scopes
-
Reconnect to the session and verify
caution
Parameters listed as [non-modifiable parameters] cannot be changed using this procedure.